public async Task <HttpResponseMessage> Post([FromBody] LeaveRegisterModel mLeaveRegisterModel) { var formatter = RequestFormat.JsonFormaterString(); string msg = ""; try { msg = await _LeaveRegisterGateway.Save(mLeaveRegisterModel); return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "success", Msg = msg }, formatter)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation { Output = "error", Msg = ex.ToString() }, formatter)); } }
public Task <string> Save(LeaveRegisterModel aModel) { try { string trNo = GetTrNo("TrNo", "tbl_HR_LEAVE_REGISTER", _trans); Con.Open(); for (int i = -1; i < (aModel.Day - 1); i++) { const string query = @"INSERT INTO tbl_HR_LEAVE_REGISTER (TrNo,EmpId,TrDate,LeaveDate,LeaveTypeId,Remarks) VALUES (@TrNo,@EmpId,@TrDate,@LeaveDate,@LeaveTypeId,@Remarks);"; var cmd = new SqlCommand(query, Con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@TrNo", trNo); cmd.Parameters.AddWithValue("@EmpId", aModel.EmCode); cmd.Parameters.AddWithValue("@TrDate", aModel.EntryDay.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@LeaveDate", aModel.LeaveFrom.AddDays(i + 1).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@LeaveTypeId", aModel.LeaveTypeId); cmd.Parameters.AddWithValue("@Remarks", aModel.Remark); //cmd.Parameters.AddWithValue("@UserName", aModel.ElementAt(0).UserName); //cmd.Parameters.AddWithValue("@BranchId", GetBranchIdByuserNameOpenCon(mInvoice.ElementAt(0).UserName)); cmd.ExecuteNonQuery(); } Con.Close(); return(Task.FromResult <string>("Save uccess")); } catch (Exception exception) { if (Con.State == ConnectionState.Open) { Con.Close(); } return(Task.FromResult(exception.Message)); } }