public bool UpdateTimeSheet(TimeSheetsEntity model)
{
this.ClearBrokenRuleMessages();
BaseValidator <TimeSheetsEntity> validator = new AddTimeSheetValidator();
if (!validator.Validate(model))
{
this.AddBrokenRuleMessages(validator.BrokenRuleMessages);
return(false);
}
if (!tsRepo.Update(model))
{
this.AddBrokenRuleMessage();
return(false);
}
return(true);
}
public int AddTimeSheet(TimeSheetsEntity model)
{
this.ClearBrokenRuleMessages();
BaseValidator <TimeSheetsEntity> validator = new AddTimeSheetValidator();
if (!validator.Validate(model))
{
this.AddBrokenRuleMessages(validator.BrokenRuleMessages);
}
int id = tsRepo.Insert(model);
if (id == 0)
{
this.AddBrokenRuleMessage();
}
if (id == -1)
{
this.AddBrokenRuleMessage("Insert Error", "You have write this ticket today,please edit it instead of add new.");
}
model.ID = id;
return(id);
}
/// <summary>
/// Bind IDataReader to Entity
/// </summary>
public static TimeSheetsEntity ReaderBind(IDataReader dataReader)
{
TimeSheetsEntity model = new TimeSheetsEntity();
object ojb;
ojb = dataReader["ID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ID = (int)ojb;
}
ojb = dataReader["SheetDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.SheetDate = (DateTime)ojb;
}
ojb = dataReader["ProjectID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProjectID = (int)ojb;
}
ojb = dataReader["TicketID"];
if (ojb != null && ojb != DBNull.Value)
{
model.TicketID = (int)ojb;
}
ojb = dataReader["UserID"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserID = (int)ojb;
}
ojb = dataReader["Hours"];
if (ojb != null && ojb != DBNull.Value)
{
model.Hours = (decimal)ojb;
}
ojb = dataReader["Percentage"];
if (ojb != null && ojb != DBNull.Value)
{
model.Percentage = (decimal)ojb;
}
model.Description = dataReader["Description"].ToString();
ojb = dataReader["IsSubmitted"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsSubmitted = (bool)ojb;
}
ojb = dataReader["CreatedOn"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreatedOn = (DateTime)ojb;
}
ojb = dataReader["CreatedBy"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreatedBy = (int)ojb;
}
ojb = dataReader["ModifiedOn"];
if (ojb != null && ojb != DBNull.Value)
{
model.ModifiedOn = (DateTime)ojb;
}
ojb = dataReader["ModifiedBy"];
if (ojb != null && ojb != DBNull.Value)
{
model.ModifiedBy = (int)ojb;
}
ojb = dataReader["IsMeeting"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsMeeting = (bool)ojb;
}
return(model);
}
