public string SaveShift(ShiftEntity shift)
{
string rv = "";
try
{
Insert_Update_Shift("sp_insert_shift", "save_shift_data", shift);
rv = Operation.Success.ToString();
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_Shift(string procedure, string callname, ShiftEntity shift)
{
_dbConn = new SqlConnection(_connectionString);
_dbConn.Open();
_cmd = new SqlCommand(procedure, _dbConn)
{
CommandType = CommandType.StoredProcedure
};
_cmd.Parameters.Add(new SqlParameter("@call_name", callname));
_cmd.Parameters.Add(new SqlParameter("@p_SID", shift.ShiftId));
_cmd.Parameters.Add(new SqlParameter("@p_ShiftNo", shift.ShiftNo));
_cmd.Parameters.Add(new SqlParameter("@p_Shift", shift.ShiftHead));
_cmd.Parameters.Add(new SqlParameter("@p_ShiftTime", shift.ShiftDuration));
_da = new SqlDataAdapter(_cmd);
_dt = new DataTable();
_da.Fill(_dt);
_dbConn.Close();
return(_dt);
}
public ShiftDTO Save(ShiftEntity newEntity)
{
var transaction = _humanManagerContext.Database.BeginTransaction();
ShiftEntity entity = null;
try
{
entity = _humanManagerContext.Shifts.Add(newEntity).Entity;
_humanManagerContext.SaveChanges();
transaction.Commit();
ShiftDTO dto = _mapper.Map <ShiftDTO>(entity);
return(dto);
}
catch
{
transaction.Rollback();
return(null);
}
}
public ActionResult SaveShift(ShiftEntity shift)
{
var res = _repository.SaveShift(shift);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public bool Delete(ShiftEntity newEntity)
{
throw new NotImplementedException();
}
