private void RemoveEditServices()
{
for (int iService = 1; iService <= cServices; iService++)
{
TableRow tr = tblServices.Rows[iService + 1];
CheckBox chkRemove = (CheckBox)tr.FindControl("chkRemove" + iService);
if (chkRemove != null && chkRemove.Checked)
{
String Sql = "";
try
{
Int32 ServiceSeq = Str.Num(WebPage.FindTextBox(ref tr, "txtServiceSeq" + iService));
Sql = "Delete From mcJobServices Where JobRno = " + JobRno + " And ServiceSeq = " + ServiceSeq;
db.Exec(Sql);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
}
private void RemoveEditDishes()
{
for (int iDish = 1; iDish <= cDishes; iDish++)
{
TableRow tr = tblDishes.Rows[iDish];
CheckBox chkRemove = (CheckBox)tr.FindControl("chkRemove" + iDish);
if (chkRemove != null && chkRemove.Checked)
{
String Sql = "";
try
{
Int32 DishSeq = Str.Num(WebPage.FindTextBox(ref tr, "txtDishSeq" + iDish));
Sql = "Delete From mcJobDishes Where JobRno = " + JobRno + " And DishSeq = " + DishSeq;
db.Exec(Sql);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
}
private void RemoveCrew()
{
for (int iCrew = 1; iCrew <= cCrew; iCrew++)
{
TableRow tr = tblCrew.Rows[iCrew];
CheckBox chkRemove = (CheckBox)tr.FindControl("chkRemove" + iCrew);
if (chkRemove != null && chkRemove.Checked)
{
String Sql = "";
try
{
Int32 CrewSeq = Str.Num(WebPage.FindTextBox(ref tr, "txtCrewSeq" + iCrew));
Sql = "Delete From mcJobCrew Where JobRno = " + JobRno + " And CrewSeq = " + CrewSeq;
db.Exec(Sql);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
}
private void SaveEditServices()
{
String Sql = "";
for (int iService = 1; iService <= cServices; iService++)
{
TableRow tr = tblServices.Rows[iService + 1];
CheckBox chkRemove = (CheckBox)tr.FindControl("chkRemove" + iService);
if (chkRemove != null && !chkRemove.Checked)
{
Int32 ServiceSeq = Str.Num(WebPage.FindTextBox(ref tr, "txtServiceSeq" + iService));
String ServiceItem = WebPage.FindTextBox(ref tr, "txtServiceItem" + iService);
String OrigServiceItem = WebPage.FindTextBox(ref tr, "txtOrigServiceItem" + iService);
bool MCCResp = FindCheckBox(ref tr, "chkMCCResp" + iService);
bool OrigMCCResp = FindCheckBox(ref tr, "chkOrigMCCResp" + iService);
bool CustomerResp = FindCheckBox(ref tr, "chkCustomerResp" + iService);
bool OrigCustomerResp = FindCheckBox(ref tr, "chkOrigCustomerResp" + iService);
String Note = WebPage.FindTextBox(ref tr, "txtNote" + iService);
String OrigNote = WebPage.FindTextBox(ref tr, "txtOrigNote" + iService);
if (ServiceItem != OrigServiceItem ||
MCCResp != OrigMCCResp ||
CustomerResp != OrigCustomerResp ||
Note != OrigNote)
{
DateTime Tm = DateTime.Now;
try
{
if (ServiceSeq == 0)
{
ServiceSeq = db.NextSeq("mcJobServices", "JobRno", JobRno, "ServiceSeq");
Sql =
"Insert Into mcJobServices (JobRno, ServiceSeq, CreatedDtTm, CreatedUser) Values (" +
JobRno + ", " +
ServiceSeq + ", " +
DB.PutDtTm(Tm) + ", " +
DB.PutStr(g.User) + ")";
db.Exec(Sql);
MCCResp = true; // set on by default for new selections
}
Sql =
"Update mcJobServices Set " +
"ServiceItem = " + DB.PutStr(ServiceItem, 50) + ", " +
"MCCRespFlg = " + DB.PutBool(MCCResp) + ", " +
"CustomerRespFlg = " + DB.PutBool(CustomerResp) + ", " +
"Note = " + DB.PutStr(Note, 128) + ", " +
"UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " +
"UpdatedUser = "******" " +
"Where JobRno = " + JobRno + " " +
"And ServiceSeq = " + ServiceSeq;
db.Exec(Sql);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
}
}
private void SaveEditDishes()
{
String Sql = "";
for (int iDish = 1; iDish <= cDishes; iDish++)
{
TableRow tr = tblDishes.Rows[iDish];
CheckBox chkRemove = (CheckBox)tr.FindControl("chkRemove" + iDish);
if (chkRemove != null && !chkRemove.Checked)
{
Int32 DishSeq = Str.Num(WebPage.FindTextBox(ref tr, "txtDishSeq" + iDish));
String DishItem = WebPage.FindTextBox(ref tr, "txtDishItem" + iDish);
String OrigDishItem = WebPage.FindTextBox(ref tr, "txtOrigDishItem" + iDish);
int Qty = Str.Num(WebPage.FindTextBox(ref tr, "txtQty" + iDish));
int OrigQty = Str.Num(WebPage.FindTextBox(ref tr, "txtOrigQty" + iDish));
String Note = WebPage.FindTextBox(ref tr, "txtNote" + iDish);
String OrigNote = WebPage.FindTextBox(ref tr, "txtOrigNote" + iDish);
//if Paper/Glass
if (!chkRemove.Visible)
{
//this is the Paper/Glass
bool fPaper = (Request.Form["rbEditPaperGlass"] == "rbEditPaper");
DishItem = cnPaperGlass;
Qty = 0;
Note = (fPaper ? cnPaper : cnGlass);
}
if (DishItem != OrigDishItem ||
Qty != OrigQty ||
Note != OrigNote)
{
DateTime Tm = DateTime.Now;
try
{
if (DishSeq == 0)
{
DishSeq = db.NextSeq("mcJobDishes", "JobRno", JobRno, "DishSeq");
Sql =
"Insert Into mcJobDishes (JobRno, DishSeq, CreatedDtTm, CreatedUser) Values (" +
JobRno + ", " +
DishSeq + ", " +
DB.PutDtTm(Tm) + ", " +
DB.PutStr(g.User) + ")";
db.Exec(Sql);
}
Sql =
"Update mcJobDishes Set " +
"DishItem = " + DB.PutStr(DishItem, 50) + ", " +
"Qty = " + Qty + ", " +
"Note = " + DB.PutStr(Note, 128) + ", " +
"UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " +
"UpdatedUser = "******" " +
"Where JobRno = " + JobRno + " " +
"And DishSeq = " + DishSeq;
db.Exec(Sql);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
}
}
private void SaveCrew()
{
String Sql = "";
String JobDate = "";
try
{
Sql = "Select JobDate From mcJobs Where JobRno = " + JobRno;
JobDate = Fmt.Dt(db.SqlDtTm(Sql));
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
for (int iCrew = 1; iCrew <= cCrew; iCrew++)
{
TableRow tr = tblCrew.Rows[iCrew];
CheckBox chkRemove = (CheckBox)tr.FindControl("chkRemove" + iCrew);
if (chkRemove != null && !chkRemove.Checked)
{
Int32 CrewSeq = Str.Num(WebPage.FindTextBox(ref tr, "txtCrewSeq" + iCrew));
String CrewMember = WebPage.FindTextBox(ref tr, "txtCrewMember" + iCrew);
String OrigCrewMember = WebPage.FindTextBox(ref tr, "txtOrigCrewMember" + iCrew);
String Assignment = WebPage.FindTextBox(ref tr, "txtAssignment" + iCrew);
String OrigAssignment = WebPage.FindTextBox(ref tr, "txtOrigAssignment" + iCrew);
String ReportTime = WebPage.FindTextBox(ref tr, "txtReportTime" + iCrew);
String OrigReportTime = WebPage.FindTextBox(ref tr, "txtOrigReportTime" + iCrew);
String Note = WebPage.FindTextBox(ref tr, "txtNote" + iCrew);
String OrigNote = WebPage.FindTextBox(ref tr, "txtOrigNote" + iCrew);
if (CrewMember != OrigCrewMember ||
Assignment != OrigAssignment ||
ReportTime != OrigReportTime ||
Note != OrigNote)
{
DateTime Tm = DateTime.Now;
try
{
if (CrewSeq == 0)
{
CrewSeq = db.NextSeq("mcJobCrew", "JobRno", JobRno, "CrewSeq");
Sql =
"Insert Into mcJobCrew (JobRno, CrewSeq, CreatedDtTm, CreatedUser) Values (" +
JobRno + ", " +
CrewSeq + ", " +
DB.PutDtTm(Tm) + ", " +
DB.PutStr(g.User) + ")";
db.Exec(Sql);
}
Sql =
"Update mcJobCrew Set " +
"CrewMember = " + DB.PutStr(CrewMember, 50) + ", " +
"CrewAssignment = " + DB.PutStr(Assignment, 50) + ", " +
"ReportTime = " + DB.PutDtTm(JobDate, ReportTime) + ", " +
"Note = " + DB.PutStr(Note, 128) + ", " +
"UpdatedDtTm = " + DB.PutDtTm(Tm) + ", " +
"UpdatedUser = "******" " +
"Where JobRno = " + JobRno + " " +
"And CrewSeq = " + CrewSeq;
db.Exec(Sql);
}
catch (Exception Ex)
{
Err Err = new Err(Ex, Sql);
Response.Write(Err.Html());
}
}
}
}
}