foreach (ManageTimeSheetsModel obj in newlist) { SqlCommand cmd = new SqlCommand("Timesheet_sp", con); cmd.Parameters.Add("@EmployeeID",SqlDbType.Int).Value=obj.EmployeeID; cmd.Parameters.Add("@OrganisationID", SqlDbType.Int).Value = obj.OrganisationID; cmd.Parameters.Add("@Timesheetdate", SqlDbType.DateTime).Value = obj.Timesheetdate; cmd.Parameters.Add("@Workinghours", SqlDbType.Decimal).Value = obj.Workinghours; cmd.Parameters.Add("@Leavehours", SqlDbType.Decimal).Value = obj.Leavehours; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = obj.status; cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = timesheet.Email; SqlParameter result = new SqlParameter("@result", SqlDbType.Int); result.Direction = ParameterDirection.Output; cmd.Parameters.Add(result); SqlParameter ErrorMessage = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 500); ErrorMessage.Direction = ParameterDirection.Output; cmd.Parameters.Add(ErrorMessage); cmd.ExecuteNonQuery(); //int id = Convert.ToInt32(result.Value.ToString()); }
public int EmployeeID { get; set; } public int OrganisationID { get; set; } public decimal Workinghours { get; set; } public decimal Leavehours { get; set; } public string status { get; set; } public DateTime Timesheetdate { get; set; } public string Email { get; set; } public DateTime StartDate { get; set; } public DateTime EndDate { get; set; }
Timesheet_sp
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)