How to save the date into database in datetime datatype in ddmmyyy hh:mm:ss from range slider
//range slider in months
function formatDate(date) {
debugger;
var monthNames = [
"January", "February", "March",
"April", "May", "June", "July",
"August", "September", "October",
"November", "December"
];
var monthIndex = date.getMonth();
var year = date.getFullYear();
return monthNames[monthIndex] + ' ' + year;
}
$(function () {
$("#slider-range").slider({
range: true,
min: new Date('01/01/2019').getTime(),
max: new Date('01/12/2019').getTime(),
step: 86400000,
values: [new Date('01/03/2019').getTime(), new Date('01/06/2019').getTime()],
slide: function (event, ui) {
$("#amount").val(formatDate(new Date(ui.values[0])) + '-' + formatDate(new Date(ui.values[1])));
},
stop: function (event, ui) {
debugger;
$("#amount").val(formatDate(new Date(ui.values[0])) + '-' + formatDate(new Date(ui.values[1])));
$.ajax({
data: { MinValue: formatDate(new Date(ui.values[0])), MaxValue: formatDate(new Date(ui.values[1])) },
type: "post",
url: apiUrl + "/api/Warehouse/addMinMaxValues",
success: function (data) {
//alert("Data Save: " + data);
}
});
}
});
$("#amount").val(formatDate((new Date($("#slider-range").slider("values", 0)))) +
" - " + formatDate((new Date($("#slider-range").slider("values", 1)))));
});
<div>
<p>
<label for="amount">Month range:</label>
<input type="text" id="amount" readonly style="border:0; color:#f6931f; font-weight:bold; width:30%">
</p>
<div id="slider-range"></div>
</div>
[HttpPost]
[ActionName("addMinMaxValues")]
public int insertMinMaxDetails(rangeSlider rs)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["ERPConnectionString"].ConnectionString;
SqlCommand sqlCmd = new SqlCommand();
DateTime now = DateTime.Now;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "INSERT_RANGE_SLIDER";
sqlCmd.Connection = myConnection;
sqlCmd.Parameters.AddWithValue("@MinValue", rs.MinValue);
sqlCmd.Parameters.AddWithValue("@MaxValue", rs.MaxValue);
myConnection.Open();
int rowInserted = sqlCmd.ExecuteNonQuery();
myConnection.Close();
return 1;
}