/*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Hss Entity Framework Auto Generated Code^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^*/
/// <summary>
/// Lock or Unlock an record
/// </summary>
/// <param name="lock_flag">lock or unlock flag</param>
/// <param name="success_flag">when unlock, indicate if it's successful</param>
public bool UpdateRecordLock(bool lock_flag, bool success_flag = false)
{
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_DailyJobs.Get_cmdTP());
if (lock_flag)
{
upd.AddValue("LastLockAt", DateTime.Now);
upd.AddValue("LastLockBy", Utility.CurrentUser);
}
else
{
if (success_flag)
{
upd.AddValue("LastRunAt", DateTime.Now);
upd.AddValue("LastRunBy", Utility.CurrentUser);
}
}
upd.AddValue("Locked", lock_flag);//set lock value
HssUtility.SQLserver.SQL_relation rela0 = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
HssUtility.SQLserver.SQL_relation rela1 = new HssUtility.SQLserver.SQL_relation("Locked", HssUtility.General.RelationalOperator.Equals, !lock_flag);
HssUtility.SQLserver.SQL_condition cond = new HssUtility.SQLserver.SQL_condition(rela0, HssUtility.General.ConditionalOperator.And, rela1);
upd.SetCondition(cond);
int count = upd.SaveToDB(Utility.Get_DRWIN_hDB());
bool flag = count > 0;
return(flag);
}
public static Hss_DailyJobs GetJob_class_id(string jobClass, int jobID)
{
if (string.IsNullOrEmpty(jobClass))
{
return(null);
}
DB_select selt = new DB_select(Hss_DailyJobs.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("Job_Class", RelationalOperator.Equals, jobClass);
SQL_relation rela1 = new SQL_relation("Job_ID", RelationalOperator.Equals, jobID);
selt.SetCondition(new SQL_condition(rela0, ConditionalOperator.And, rela1));
Hss_DailyJobs hdj = null;
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
if (reader.Read())
{
hdj = new Hss_DailyJobs();
hdj.Init_from_reader(reader);
}
reader.Close();
return(hdj);
}
private bool PreConnect_check()
{
DateTime currTime = DateTime.Now;
//run Monday to Friday
if (currTime.DayOfWeek == DayOfWeek.Saturday || currTime.DayOfWeek == DayOfWeek.Sunday)
{
return(false);
}
//run between 8am to 8pm for Admin
if (currTime.Hour < 8 || currTime.Hour > 20)
{
return(false);
}
this.hdj = Hss_DailyJobs_master.GetJob_class_id("Inbound Data", 3);
if (this.hdj == null)
{
return(false);
}
else
{
this.notes = this.hdj.Notes.Value;
}
if (HssDateTime.CompareDateTime_day(currTime, this.hdj.LastRunAt.Value) <= 0)
{
Console.WriteLine("---> InboundData3_SPR info 0: Task previous run at " + this.hdj.LastRunAt.Value);
return(false);
}
return(true);
}
/*---------------------------------------------------------------------------------------------------------------------------------------*/
private void main_ultraGrid_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
{
int detail_id = (int)e.Cell.Row.Cells["ID"].Value;
Hss_DailyJobs td = new Hss_DailyJobs(detail_id);
td.Init_from_DB();
Models_viewForm mvf = td.GetEditForm();
mvf.Refresh_parentUI = this.RefreshMainGrid;
mvf.Show();
}
public static List <Hss_DailyJobs> GetAllJobs()
{
List <Hss_DailyJobs> list = new List <Hss_DailyJobs>();
DB_select selt = new DB_select(Hss_DailyJobs.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Hss_DailyJobs hdj = new Hss_DailyJobs();
hdj.Init_from_reader(reader);
list.Add(hdj);
}
reader.Close();
return(list);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_DailyJobs.Get_cmdTP());
if (this.Job_Class.ValueChanged)
{
upd.AddValue("Job_Class", this.Job_Class); /*Optional 2*/
}
if (this.Job_ID.ValueChanged)
{
upd.AddValue("Job_ID", this.Job_ID); /*Optional 3*/
}
if (this.LastRunAt.ValueChanged)
{
upd.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/
}
if (this.LastRunBy.ValueChanged)
{
upd.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/
}
if (this.Locked.ValueChanged)
{
upd.AddValue("Locked", this.Locked); /*Optional 6*/
}
if (this.Notes.ValueChanged)
{
upd.AddValue("Notes", this.Notes); /*Optional 7*/
}
if (this.LastLockAt.ValueChanged)
{
upd.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/
}
if (this.LastLockBy.ValueChanged)
{
upd.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
public Hss_DailyJobs GetCopy()
{
Hss_DailyJobs newEntity = new Hss_DailyJobs();
if (!this.Job_Class.IsNull_flag)
{
newEntity.Job_Class.Value = this.Job_Class.Value;
}
if (!this.Job_ID.IsNull_flag)
{
newEntity.Job_ID.Value = this.Job_ID.Value;
}
if (!this.LastRunAt.IsNull_flag)
{
newEntity.LastRunAt.Value = this.LastRunAt.Value;
}
if (!this.LastRunBy.IsNull_flag)
{
newEntity.LastRunBy.Value = this.LastRunBy.Value;
}
if (!this.Locked.IsNull_flag)
{
newEntity.Locked.Value = this.Locked.Value;
}
if (!this.Notes.IsNull_flag)
{
newEntity.Notes.Value = this.Notes.Value;
}
if (!this.LastLockAt.IsNull_flag)
{
newEntity.LastLockAt.Value = this.LastLockAt.Value;
}
if (!this.LastLockBy.IsNull_flag)
{
newEntity.LastLockBy.Value = this.LastLockBy.Value;
}
return(newEntity);
}
/// <summary>
/// Initialize object from DB
/// </summary>
public bool Init_from_DB()
{
if (this.ID < 0)
{
return(false);
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Hss_DailyJobs.Get_cmdTP());
db_sel.tableName = "Hss_DailyJobs";
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.ID);
db_sel.SetCondition(rela);
bool res_flag = false;
HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_DRWIN_hDB());
if (reader.Read())
{
this.Init_from_reader(reader);
res_flag = true;
}
reader.Close();
return(res_flag);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_DailyJobs.Get_cmdTP());
dbIns.AddValue("Job_Class", this.Job_Class); /*Optional 2*/
dbIns.AddValue("Job_ID", this.Job_ID); /*Optional 3*/
dbIns.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/
dbIns.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/
dbIns.AddValue("Locked", this.Locked); /*Optional 6*/
dbIns.AddValue("Notes", this.Notes); /*Optional 7*/
dbIns.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/
dbIns.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/
return(dbIns);
}
