public int UpdateShiftMaster(ShiftMasterModel objShiftMasterModel) { SqlParameter[] paramAdd = new SqlParameter[5]; paramAdd[0] = new SqlParameter("@ShiftName", SqlDbType.VarChar, 100); paramAdd[0].Value = objShiftMasterModel.shiftName; //paramAdd[1] = new SqlParameter("@Description", SqlDbType.VarChar, 100); //paramAdd[1].Value = objShiftMasterModel.description; paramAdd[1] = new SqlParameter("@ShiftInTime", SqlDbType.DateTime); paramAdd[1].Value = objShiftMasterModel.shiftInTime; paramAdd[2] = new SqlParameter("@ShiftOutTime", SqlDbType.DateTime); paramAdd[2].Value = objShiftMasterModel.shiftOutTime; paramAdd[3] = new SqlParameter("@ISActive", SqlDbType.Bit); paramAdd[3].Value = objShiftMasterModel.isActive; paramAdd[4] = new SqlParameter("@ShiftID", SqlDbType.Int); paramAdd[4].Value = objShiftMasterModel.shiftID; try { return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "UpdateShiftMaster", paramAdd)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "ShiftMasterDAL.cs", "UpdateShiftMaster", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public int UpdateShiftMaster(ShiftMasterModel objShiftMasterModel) { try { return(objShiftMasterDAL.UpdateShiftMaster(objShiftMasterModel)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "ShiftMasterBOL.cs", "UpdateShiftDetails", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }