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));
}
}
