public void AddRequest()
{
//Add the record to the Partial Time Request Table
DBContext.PartialTime_Requests request = new DBContext.PartialTime_Requests();
request.RequestId = RequestId;
request.UserId = User.ID;
request.SubmitedDate = DateTime.UtcNow;
request.RequestDate = RequestDate;
request.StartTime = Utilities.Helper.convertToUTC(StartTime);
request.EndTime = StartTime.Add(Duration);
request.Duration = Duration;
request.Comment = Comments;
request.ProjectId = ProjectId;
request.Approver = Approver;
request.Status = Status;
try
{
db.PartialTime_Requests.Add(request);
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdateStatus(DBContext.PartialTime_Requests rec, string newStatus)
{
if (rec == null)
{
throw new ArgumentNullException("Record from Db cannot be null");
}
if (String.IsNullOrEmpty(newStatus))
{
throw new ArgumentNullException("Status Argument cannot be null or Empty");
}
var db = new DBContext.DBModel();
rec.Status = newStatus;
try
{
db.PartialTime_Requests.Attach(rec);
db.SaveChanges();
}
catch (Exception ex)
{
//log the error;
throw ex;
}
}
public OvertimeRequest(DBContext.PartialTime_Requests record)
{
if (record == null)
{
throw new ArgumentNullException("The argument record cannot be null!");
}
RequestId = record.RequestId;
User.ID = record.UserId;
RequestDate = record.RequestDate;
StartTime = record.StartTime;
Duration = record.Duration;
Comments = record.Comment;
ProjectId = (int)record.ProjectId;
Approver = record.Approver;
Status = record.Status;
}
public PartialRequestDb(DBContext.PartialTime_Requests db)
{
if (db == null)
{
throw new ArgumentNullException("Argument from DB cannot be null.");
}
UserId = db.UserId;
RequestTime = db.RequestTime;
RequestDate = db.RequestDate;
StarTime = db.StartTime;
EndTime = db.EndTime;
Duration = db.Duration;
ProjectId = (int)db.ProjectId;
Approver = db.Approver;
Status = db.Status;
Comment = db.Comment;
}
public static void AddRecord(DBContext.PartialTime_Requests rec)
{
if (rec == null)
{
throw new ArgumentNullException("Argument cannot be null.");
}
var db = new DBContext.DBModel();
try
{
db.PartialTime_Requests.Add(rec);
db.SaveChanges();
}
catch (Exception ex)
{
//log error
throw ex;
}
}
