Thursday, 12 May 2022

Connect To My Sql Database With Entity Framework Using C# | My SQL And Asp.Net Core 6/7

In this article i will show you how you can connect and fetch data from my sql database in your asp.net core 6 application.

5/12/2022 - By Pranav Singh 0

Tuesday, 8 February 2022

Download File From wwwroot Folder Asp.Net Core 6 Using C#

In this article i will show you how you can download the uploaded file in wwwroot folder in your asp.net core 6 / mvc application.

In my previous article i have shown you how you can upload file in asp.net core 6 using c# and other article like upload file and rename it before uploading in wwwroot folder in asp.net core .

Now for this article we will create a new asp.net core application and in wwwroot folder we will add a static file in it. This file we will download on button click on our asp.net core application.

This file is present in wwwroot folder

Now on controller end we will create a httpget method.

[HttpGet]

public IActionResult Index()

{

return View();

}

After this we will create a view and and add link or button control. On click on this control we will download the file.

ViewData["Title"] = "Page";

}

<h1>Click Link to download file</h1><br /><br />

<a href="/Home/Index/" title="Download file"><b>DOWNLOAD</b></a>

</div>

After this we will write code to download the file. For this we will create a HttpPost method in controller.

public IActionResult DownloadFile()

{

var memory = DownloadSinghFile("TextFile.txt", "wwwwroot");

return File(memory.ToArray(), "text/plain", "TextFile.txt");

}

private MemoryStream DownloadSinghFile(string filename, string uploadPath)

{

var path = Path.Combine(Directory.GetCurrentDirectory(), uploadPath, filename);

var memory = new MemoryStream();

if (System.IO.File.Exists(path))

{

var net = new System.Net.WebClient();

var data = net.DownloadData(path);

var content = new System.IO.MemoryStream(data);

memory = content;

}

memory.Position = 0;

return memory;

}

In above code i have passed the file detail and return type of the function is MonoryStream. After that i have user File return type to convert the memorystream in file. In this file return type you must pass the type and file name. Here is the list of file type which you can refer.

{".txt", "text/plain"},

{".pdf", "application/pdf"},

{".doc", "application/vnd.ms-word"},

{".docx", "application/vnd.ms-word"},

{".xls", "application/vnd.ms-excel"},

{".xlsx", "application/vnd.ms-excel"},

{".png", "image/png"},

{".jpg", "image/jpeg"},

{".jpeg", "image/jpeg"},

{".gif", "image/gif"},

{".csv", "text/csv"},

{".zip", "application/zip"}

Now we have done run the code to check the output.

Now click on download link to download the file.

Download

2/08/2022 - By Pranav Singh 0

Monday, 7 February 2022

Asp.net Core 6: Bind(Populate) List Model Property in Table Control & Access Value In Controller Using C#.Net

In this article i will show you how you can bind the model class property of list type to control present in table and access the added value at controller end in asp.net core using C#.net.

Now for this article first we will create a new asp.net core and create a mode class file.

public class EmployeeModel

{

public List<EmployeeDetail> EmployeeList { get; set; }

}

public class EmployeeDetail

{

public int Id { get; set; }

public string EmployeeName { get; set; }

public string Location { get; set; }

public int Salery { get; set; }

}

After this model we will add the HttpGet method in the controller. In this method we will create the object of model class, and pass it to the view to bind it to control.

[HttpGet]

public IActionResult Index()

{

EmployeeModel employeeModel = new EmployeeModel();

employeeModel.EmployeeList = new List<EmployeeDetail>();

//Here i have adding donw dummy value as id

//In this we will create 5 rows

for (int i = 0; i < 5; i++)

{

employeeModel.EmployeeList.Add(new EmployeeDetail

{

Id = i

});

}

return View(employeeModel);

}

In above code i have added 3 rows to the list. Ones be bind we will get 3 rows table and we will provide other detail and try to access it. This is just for generating no of rows to the list. You can use your own model with data in list to bind. After this we will create .cshtml view file and add the below code.

@model Project.Models.EmployeeModel

ViewData["Title"] = "Page";

}

@using (Html.BeginForm("Index", "Home", FormMethod.Post, new { @enctype = "multipart/form-data" }))

{

<thead>

<tr>

<td>Location</td>

<td>Salery</td>

</tr>

</thead>

<tbody>

@{ int count = 0;}

@foreach (var item in Model.EmployeeList)

{

<tr>

<td>@Html.TextBoxFor(m => Model.EmployeeList[count].EmployeeName, new { @class = "form-control" })</td>

<td>@Html.TextBoxFor(m => Model.EmployeeList[count].Location, new { @class = "form-control" })</td>

<td>@Html.TextBoxFor(m => Model.EmployeeList[count].Salery, new { @class = "form-control" })</td>

</tr>

count = count + 1;

}

</tbody>

</table>

</div>

}

In above code i have used foreach loop to generate the rows. In this i have taken the index variable named as count. I am increasing each time in look. In this I have used model list by assigning the index of each and every control. Now we have done run the code to check the output.

Asp.net Core 6: Bind(Populate) List Model Property in Table Control & Access Value In Controller Using C#.Net

Above tis the table. Now add some value and click on submit button.

Now below you can see that we are getting the table model in model class list.

2/07/2022 - By Pranav Singh 0

Thursday, 3 February 2022

Add Number of Days To Date in jQuery | jQuery Add Days To Date dd/mm/yyyy

In this article i will show you how you can add no of days to the to user entered date using jquery. So for this first we will add the jquery library reference into the project and add the date in dd/mm/yyyy format into the textbox.

Here is html of the entry form.

Enter Date: <input type="text" placeholder="dd/mm/yyyy" id="txtuserinoutdate" /><br />

No of Days: <input type="text" placeholder="noofdays" id="txtnoofdays" /><br />

Calculated Date: <input type="text" placeholder="dd/mm/yyyy" id="txtcalculateddate" />

<br />

</div>

Now we will add the jQuery file reference and add the add the below javascript function code.

var CalculateDate = function () {

var userdate = new Date($("#txtuserinoutdate").val());

var noofdays = $("#txtnoofdays").val();

var calculateddate = new Date(addDays(getFormattedString(userdate), noofdays));

$("#txtcalculateddate").val(getFormattedString(calculateddate));

}

var getFormattedString = function (d) {

return ('0' + d.getDate()).toString().slice(-2) + "/" + ('0' + (d.getMonth() + 1)).toString().slice(-2) + "/" + d.getFullYear();

}

var addDays = function (input_date, days) {

var currentDate = new Date(input_date);

if (days != 0) {

currentDate.setDate(currentDate.getDate() + parseInt(days));

}

return currentDate;

}

In above code i have used three javascript function. In this first function is called on click event of the button control and on other hand getformatedString is used for reformatting the user entered date. and addDays function is used for adding the no of days to the user provided date in dd/mm/yyyy format. Now we have done run the page and check the output.