public IHttpActionResult PutShift(ShiftMaster shift)
{
using (var ctx = new sdirecttestdbEntities1())
{
var existingShift = ctx.ShiftMasters.Where(s => s.ShiftId == shift.ShiftId)
.FirstOrDefault <ShiftMaster>();
if (existingShift != null)
{
existingShift.ShiftName = shift.ShiftName;
existingShift.StartTime = shift.StartTime;
existingShift.EndTime = shift.EndTime;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public ShiftMaster GetShiftMasterRecord(string recordID, string UserID)
{
ShiftMaster shiftMaster = new ShiftMaster();
SqlDataReader dr = null;
try
{
SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@UserID", Convert.ToInt32(UserID)) };
dr = SqlHelper.ExecuteReader(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordShiftMaster", Parameters);
if (dr.Read())
{
shiftMaster.SNo = Convert.ToInt32(dr["SNo"]);
shiftMaster.ShiftName = Convert.ToString(dr["ShiftName"]);
shiftMaster.TimeIn = Convert.ToString(dr["TimeIn"]);
shiftMaster.TimeOut = Convert.ToString(dr["TimeOut"]);
shiftMaster.NextDay = Convert.ToBoolean(dr["NextDay"]);
shiftMaster.IsActive = Convert.ToBoolean(dr["IsActive"]);
//shiftMaster.CreatedOn = Convert.ToString(dr["CreatedOn"]);
shiftMaster.CreatedBy = Convert.ToString(dr["CreatedBy"]);
shiftMaster.UpdatedBy = Convert.ToString(dr["UpdatedBy"]);
//shiftMaster.UpdatedOn = Convert.ToString(dr["UpdatedOn"]);
shiftMaster.Active = Convert.ToString(dr["Active"]);
shiftMaster.DayNext = Convert.ToString(dr["DayNext"]);
}
}
catch (Exception ex)// (Exception ex)
{
dr.Close();
}
return(shiftMaster);
}
public ActionResult AddShiftDetails(ShiftMaster SM)
{
if (ModelState.IsValid)
{
SM.Created_By = Session["LogedUserID"] as string;
SM.Created_On = DateTime.Now;
db.ShiftMasters.Add(SM);
db.SaveChanges();
return(RedirectToAction("ShiftDetails"));
}
return(RedirectToAction("AddShiftDetails"));
}
public string SaveShiftMaster(int shiftId, string shiftName, TimeSpan fromTime, TimeSpan toTime, Int64 mgrId)
{
try
{
int isSaved = 0;
using (var context = new NLTDDbContext())
{
var exists = context.ShiftMaster.Where(c => c.FromTime == fromTime && c.ToTime == toTime && c.ShiftID != shiftId).ToList();
if (exists != null && exists.Count > 0)
{
return("Shift Already Available.");
}
else
{
var objShiftMaster = context.ShiftMaster.Where(c => c.ShiftID == shiftId).SingleOrDefault();
if (objShiftMaster != null)
{
objShiftMaster = context.ShiftMaster.Where(c => c.ShiftID == shiftId).Single();
objShiftMaster.ShiftID = shiftId;
objShiftMaster.ShiftDescription = shiftName;
objShiftMaster.FromTime = fromTime;
objShiftMaster.ToTime = toTime;
}
else
{
objShiftMaster = new ShiftMaster
{
ShiftDescription = shiftName,
FromTime = fromTime,
ToTime = toTime,
CreatedBy = mgrId,
CreatedDate = DateTime.Now
};
}
context.ShiftMaster.AddOrUpdate(objShiftMaster);
isSaved = context.SaveChanges();
}
}
return(isSaved > 0 ? "Saved" : "Failed");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public IHttpActionResult PostShift(ShiftMaster shiftMaster)
{
using (var ctx = new sdirecttestdbEntities1())
{
ctx.ShiftMasters.Add(new ShiftMaster()
{
ShiftId = shiftMaster.ShiftId,
ShiftName = shiftMaster.ShiftName,
StartTime = shiftMaster.StartTime,
EndTime = shiftMaster.EndTime
});
ctx.SaveChanges();
}
return(Ok());
}
public int AddShift(ShiftMaster _master, string Otype)
{
DALCommon dal = new DALCommon(ConStr);
return(dal.AddShift(_master, Otype));
}
public ShiftMasterVM SaveShift(ShiftMasterVM Sft)
{
int n;
int k = 0;
string Dst1, Dst2 = null;
DateTime dt1, dt2;
string Approved;
if (!Sft.EditFlag)
{
ShiftMaster pt = new ShiftMaster();
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + Sft.CmpyCode + "' and Code='PRSFT' ");
//pt.PRBM001_code = string.Concat("PRBM", "-", (pno + 1).ToString().PadLeft(4, '0')).ToString();
List <ShiftAllocationH> ObjList = new List <ShiftAllocationH>();
ObjList.AddRange(Sft.Shift.Select(m => new ShiftAllocationH
{
CmpyCode = m.CmpyCode,
PRSFT002_code = m.PRSFT002_code,
PRSFT001_code = m.PRSFT001_code,
Enttry_Date = m.Enttry_Date,
Effect_Date = m.Effect_Date,
division = m.division,
ApprovalYN = m.ApprovalYN,
}).ToList());
k = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT001 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "' ");
n = ObjList.Count;
if (n != 0 && k == 0)
{
using (TransactionScope scope = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT001(PRSFT001_code,CmpyCode,country,division,ShiftName,StTime,EdTime) values('" + Sft.PRSFT001_code + "','" + Sft.CmpyCode + "','" + Sft.country + "','" + Sft.division + "','" + Sft.ShiftName + "','" + Sft.StTime + "','" + Sft.EdTime + "')");
while (n > 0)
{
dt1 = Convert.ToDateTime(ObjList[n - 1].Enttry_Date.ToString());
Dst1 = dt1.ToString("yyyy-MM-dd hh:mm:ss tt");
dt2 = Convert.ToDateTime(ObjList[n - 1].Effect_Date.ToString());
Dst2 = dt2.ToString("yyyy-MM-dd hh:mm:ss tt");
//if (ObjList[n - 1].ApprovalYN ="YES")
// Approved = "Y";
//else
// Approved = "N";
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT002(PRSFT001_code,PRSFT002_code,CmpyCode,division,Enttry_Date,Effect_Date,ApprovalYN) values('" + Sft.PRSFT001_code + "','" + ObjList[n - 1].PRSFT002_code + "','" + Sft.CmpyCode + "', '" + ObjList[n - 1].division + "', '" + Dst1 + "', '" + Dst2 + "', '" + ObjList[n - 1].ApprovalYN + "')");
n = n - 1;
}
_EzBusinessHelper.ActivityLog(Sft.CmpyCode, Sft.UserName, "Add Shift Master", Sft.PRSFT001_code, Environment.MachineName);
_EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos =" + (pno + 1) + " where CmpyCode='" + Sft.CmpyCode + "' and Code='PRSFT'");
Sft.SaveFlag = true;
Sft.ErrorMessage = string.Empty;
scope.Complete();
}
}
else
{
Sft.SaveFlag = true;
Sft.ErrorMessage = "Duplicate Record";
}
}
else
{
k = 0;//_EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT003 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRSFT001 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "' ");
if (n != 0 && k == 0)
{
string DT1, DT2;
using (TransactionScope scope1 = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("delete from PRSFT001 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
_EzBusinessHelper.ExecuteNonQuery("delete from PRSFT002 where CmpyCode='" + Sft.CmpyCode + "' and PRSFT001_code='" + Sft.PRSFT001_code + "'");
ShiftMaster pt = new ShiftMaster();
List <ShiftAllocationH> ObjList = new List <ShiftAllocationH>();
ObjList.AddRange(Sft.Shift.Select(m => new ShiftAllocationH
{
PRSFT001_code = m.PRSFT001_code,
PRSFT002_code = m.PRSFT002_code,
CmpyCode = m.CmpyCode,
ApprovalYN = m.ApprovalYN,
division = m.division,
Effect_Date = m.Effect_Date,
Enttry_Date = m.Enttry_Date
}).ToList());
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT001(PRSFT001_code,CmpyCode,country,division,ShiftName,StTime,EdTime) values('" + Sft.PRSFT001_code + "','" + Sft.CmpyCode + "','" + Sft.country + "','" + Sft.division + "','" + Sft.ShiftName + "','" + Sft.StTime + "','" + Sft.EdTime + "')");
n = ObjList.Count;
while (n > 0)
{
dt1 = Convert.ToDateTime(ObjList[n - 1].Enttry_Date.ToString());
Dst1 = dt1.ToString("yyyy-MM-dd hh:mm:ss tt");
dt2 = Convert.ToDateTime(ObjList[n - 1].Effect_Date.ToString());
Dst2 = dt2.ToString("yyyy-MM-dd hh:mm:ss tt");
_EzBusinessHelper.ExecuteNonQuery("insert into PRSFT002(PRSFT001_code,PRSFT002_code,CmpyCode,division,Enttry_Date,Effect_Date,ApprovalYN) values('" + Sft.PRSFT001_code + "','" + ObjList[n - 1].PRSFT002_code + "','" + Sft.CmpyCode + "', '" + ObjList[n - 1].division + "', '" + Dst1 + "', '" + Dst2 + "', '" + ObjList[n - 1].ApprovalYN + "')");
n = n - 1;
}
_EzBusinessHelper.ActivityLog(Sft.CmpyCode, Sft.UserName, "Update Shift Master", Sft.PRSFT001_code, Environment.MachineName);
Sft.SaveFlag = true;
Sft.ErrorMessage = string.Empty;
scope1.Complete();
}
}
else
{
Sft.SaveFlag = true;
Sft.ErrorMessage = "Error occur";
}
}
return(Sft);
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditShift(ShiftCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var res = db.ShiftMaster.Where(m => m.ShiftId == data.shiftId).FirstOrDefault();
if (res == null)
{
try
{
ShiftMaster item = new ShiftMaster();
item.ShiftName = data.shiftName;
item.ShiftDescription = data.shiftDescription;
item.ShiftStartTimings = data.shiftStartTimings;
item.ShiftEndTimings = data.shiftEndTimings;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.ShiftMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.ShiftName = data.shiftName;
res.ShiftDescription = data.shiftDescription;
res.ShiftStartTimings = data.shiftStartTimings;
res.ShiftEndTimings = data.shiftEndTimings;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
