public object TermCommencementUpdate(TermCommencementUpdateParam b)
{
if (b.TermID == 0)
{
return(new Error()
{
IsError = true, Message = "Required Terminal"
});
}
var data = db.Tbl_TermCommencementDate.Where(r => r.TermCommID == b.TermCommID).FirstOrDefault();
try
{
Tbl_TermCommencementDate obj = new Tbl_TermCommencementDate();
data.TermID = b.TermID;
data.ModifiedBy = null;
data.ModifiedDate = System.DateTime.Today.Date;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Update Term"
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object DeleteTermCommencement(TermCommencementUpdateParam PM)
{
try
{
Tbl_TermCommencementDate obj = db.Tbl_TermCommencementDate.Where(r => r.TermCommID == PM.TermCommID).FirstOrDefault();
if (obj.Status == 1)
{
obj.Status = 0;
}
else
{
obj.Status = 1;
}
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Unit Deactivated Successfully."
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
//TermCommencement
public object SaveTermCommencement(TermCommencementParam b)
{
if (b.TermID == 0)
{
return(new Error()
{
IsError = true, Message = "Required Terminal"
});
}
var data = db.Tbl_TermCommencementDate.FirstOrDefault(r => r.TermID == b.TermID);
if (data != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowed"
});
}
try
{
Tbl_TermCommencementDate obj = new Tbl_TermCommencementDate();
obj.TermID = b.TermID;
obj.StartDate = b.StartDate;
obj.EndDate = b.EndDate;
obj.Status = 1;
obj.CreatedBy = 1;
obj.CreatedDate = System.DateTime.Today.Date;
obj.ModifiedBy = null;
obj.ModifiedDate = System.DateTime.Today.Date;
db.Tbl_TermCommencementDate.Add(obj);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Created Term"
});
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}