public Boolean updateSEFCheckList(sefcheck flim)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update SEFCheckList set SequenceNo='" + flim.Sequenceno + "', Description = '" + flim.description + "'," +
" Status='" + flim.Status + "'" +
" where RowID='" + flim.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "SEFCheckList", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean insertTaxCode(taxcode tc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into TaxCode (TaxCode,Description,Status,CreateTime,CreateUser)" +
"values (" +
"'" + tc.TaxCode + "'," +
"'" + tc.Description + "'," +
tc.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "TaxCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean reversePR(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update PurchaseReturnHeader set DocumentStatus=" + prh.DocumentStatus +
", forwardUser='******'" +
", commentStatus='" + prh.CommentStatus + "'" +
", ForwarderList='" + prh.ForwarderList + "'" +
" where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveProjectHeader(projectheader prevpheader)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProjectHeader set DocumentStatus=99" +
", Status=1" +
", ApproveUser='******'" +
", TrackingNo=" + prevpheader.TrackingNo +
", TrackingDate=convert(date, getdate())" +
" where DocumentID='" + prevpheader.DocumentID +
"' and TemporaryNo=" + prevpheader.TemporaryNo +
" and TemporaryDate='" + prevpheader.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "ProjectHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertStockEmpMapping(storeempmapping sem)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into StoreEmpMapping (StoreLocationID,EmployeeID,Status,CreateTime,CreateUser)" +
"values (" +
"'" + sem.StoreLocationID + "'," +
"'" + sem.EmployeeID + "'," +
sem.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "StoreEmpMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertHSNCOde(serviceHSNMapping map)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into ServiceHSNMapping (ServiceItemID,HSNCode,Status,CreateTime,CreateUser)" +
" values (" +
"'" + map.ServiceItemID + "'," +
"'" + map.HSNCode + "'," +
map.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ServiceHSNMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateProjectHeader(projectheader pheader, projectheader prevpheader)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProjectHeader set CustomerID='" + pheader.CustomerID + "'" +
", Status=" + pheader.Status +
", ProjectID ='" + pheader.ProjectID +
"', OfficeID ='" + pheader.OfficeID +
"', ProjectManager='" + pheader.ProjectManager +
"', StartDate='" + pheader.StartDate.ToString("yyyy-MM-dd") +
"', TargetDate='" + pheader.TargetDate.ToString("yyyy-MM-dd") +
"', ShortDescription='" + pheader.ShortDescription +
"', ForwarderList='" + pheader.ForwarderList +
"' where DocumentID='" + prevpheader.DocumentID +
"' and TemporaryNo=" + prevpheader.TemporaryNo +
" and TemporaryDate='" + prevpheader.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProjectHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updatejvaccmapping(jvaccmapping doc, jvaccmapping prevdoc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update AutoJVAccountCodes set AccountCodeDebit='" + doc.AccountCodeDebit + "'," +
"AccountCodeCredit='" + doc.AccountCodeCredit + "'," +
" Status=" + doc.Status +
" where RowID=" + prevdoc.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "AutoJVAccountCodes", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean ApproveWorkOrder(workorderheader woh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update WOHeader set DocumentStatus=99, status=1, WorkOrderStatus = 1 " +
", ApproveUser='******'" +
", commentStatus='" + woh.CommentStatus + "'" +
", WONo=" + woh.WONo +
", WODate=convert(date, getdate())" +
" where DocumentID='" + woh.DocumentID + "'" +
" and TemporaryNo=" + woh.TemporaryNo +
" and TemporaryDate='" + woh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "WOHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateDocumentReceiver(documentreceiver doc, documentreceiver prevdoc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update DocumentReceiver set EmployeeID='" + doc.EmployeeID + "'," +
"OfficeID='" + doc.OfficeID + "'," +
" Status=" + doc.Status +
" where RowID=" + prevdoc.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "DocumentReceiver", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean insertAutoJVAccountCodes(jvaccmapping doc)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into AutoJVAccountCodes (JVName,DocumentID,AccountCodeDebit,AccountCodeCredit,Status)" +
" values (" +
"'" + doc.JVName + "'," +
"'" + doc.DocumentID + "'," +
"'" + doc.AccountCodeDebit + "'," +
"'" + doc.AccountCodeCredit + "'," +
doc.Status + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "AutoJVAccountCodes", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean insertLeaveCompOff(leavecompoff lco)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
updateSQL = "insert into LeaveEarning (EmployeeID,LeaveID,Date,Status,CreateTime,CreateUser)" +
"values (" +
"'" + lco.EmployeeID + "'," +
"'CO','" +
lco.cdate + "'," + 1 + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "LeaveEarning", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertData(cmpnydata dat)
{
Boolean status = true;
string utString = "";
try
{
string updatesql = "Delete from CompanyData Where CompanyID='" + dat.CompanyID + "'" +
" and DataID='" + dat.DataID + "' ";
utString = utString + updatesql + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "CompanyData", "", updatesql) +
Main.QueryDelimiter;
updatesql = "insert into CompanyData (CompanyID,DataID,DataValue,Status) " +
"values (" +
"'" + dat.CompanyID + "'," +
"'" + dat.DataID + "'," +
"'" + dat.DataValue + "'," +
dat.status + ")";
utString = utString + updatesql + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "CompanyData", "", updatesql) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean updateData(cmpnydata dat)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update CompanyData set DataValue='" + dat.DataValue +
"',Status=" + dat.status +
" where CompanyID='" + dat.CompanyID + "' and DataID='" + dat.DataID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "CompanyData", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean updateFinancialYear(financialyear fyrec)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update FinancialYear set startDate='" +
(fyrec.startDate.ToString("yyyyMMdd HH:mm:ss")) +
"',EndDate='" + (fyrec.endDate.ToString("yyyyMMdd HH:mm:ss")) +
"',Status=" + fyrec.status + ", IsCurrentFY = " + fyrec.IsCurrentFY +
" where FYID='" + fyrec.fyID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "FinancialYear", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean insertOffice(office off)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into Office (OfficeID,Name,RegionID,Address1,Address2,Address3,Address4,Status,CreateTime,CreateUser)" +
"values (" +
"'" + off.OfficeID + "'," +
"'" + off.name + "'," +
"'" + off.RegionID + "'," +
"'" + off.Address1 + "'," +
"'" + off.Address2 + "'," +
"'" + off.Address3 + "'," +
"'" + off.Address4 + "'," +
off.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "Office", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertFinancialYear(financialyear fyrec)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into FinancialYear (FYID,startdate,enddate,status,documentstatus,CreateTime,CreateUser) values (" +
"'" + fyrec.fyID + "'," +
"'" + (fyrec.startDate.ToString("yyyyMMdd HH:mm:ss")) + "'," +
"'" + (fyrec.endDate.ToString("yyyyMMdd HH:mm:ss")) + "'," +
fyrec.status + "," + fyrec.documentStatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "FinancialYear", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean updateOffice(office off)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update Office set name='" + off.name +
"', RegionID='" + off.RegionID +
"', Address1='" + off.Address1 +
"', Address2='" + off.Address2 +
"', Address3='" + off.Address3 +
"', Address4='" + off.Address4 +
"',Status=" + off.status +
" where OfficeID='" + off.OfficeID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "Office", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateHSNCode(serviceHSNMapping map)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ServiceHSNMapping set HSNCode='" + map.HSNCode +
"',Status=" + map.Status +
" where RowID=" + map.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ServiceHSNMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveDebitNoteHeader(DebitNoteHeader dnh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update DebitNoteHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", commentStatus='" + dnh.CommentStatus + "'" +
", DebitNoteNo =" + dnh.DebitNoteNo +
", DebitNoteDate=convert(date, getdate())" +
" where DocumentID='" + dnh.DocumentID + "'" +
" and TemporaryNo=" + dnh.TemporaryNo +
" and TemporaryDate='" + dnh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "DebitNoteHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean forwardProjectHeader(projectheader prevpheader)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProjectHeader set DocumentStatus=" + (prevpheader.DocumentStatus + 1) +
", forwardUser='******'" +
", ForwarderList='" + prevpheader.ForwarderList + "'" +
" where DocumentID='" + prevpheader.DocumentID +
"' and TemporaryNo=" + prevpheader.TemporaryNo +
" and TemporaryDate='" + prevpheader.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("forward", "ProjectHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateAccountCodeDetails(accountcode accode, accountcode prevaccode)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update AccountCode set " +
"Name='" + accode.Name +
"', GroupLevel1='" + accode.GroupLevel1 +
"', GroupLevel2='" + accode.GroupLevel2 +
"', GroupLevel3='" + accode.GroupLevel3 +
"', GroupLevel4='" + accode.GroupLevel4 +
"', GroupLevel5='" + accode.GroupLevel5 +
"', ForwarderList='" + accode.ForwarderList + "'" +
", Status=" + accode.status +
" where AccountCode='" + prevaccode.AccountCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "AccoutCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean updateStockEmpMapping(storeempmapping sem)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update StoreEmpMapping set Status = " + sem.Status +
" where StoreLocationID='" + sem.StoreLocationID + "'" +
" and EmployeeID='" + sem.EmployeeID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "StoreEmpMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveAccountCode(accountcode prevaccode, string id)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update AccountCode set AccountCode = '" + id +
"', documentstatus=99" +
", status=1" +
", ApproveUser='******'" +
" where AccountCode='" + prevaccode.AccountCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "AccountCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean updateTaxCode(taxcode tc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update TaxCode set Description='" + tc.Description +
"', Status=" + tc.status +
" where TaxCode='" + tc.TaxCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "TaxCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean reverseAccountCode(accountcode accode)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update AccountCode set DocumentStatus=" + accode.documentStatus +
", forwardUser='******'" +
", ForwarderList='" + accode.ForwarderList + "'" +
" where AccountCode='" + accode.AccountCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "AccountCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean deletePRHeader(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "delete PurchaseReturnHeader where DocumentID='" + prh.DocumentID + "'" +
" and TemporaryNo=" + prh.TemporaryNo +
" and TemporaryDate='" + prh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "PurchaseReturnHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean FinalizeProductTestTemp(producttesttemplateheader pttemp)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductTestTemplateHeader set Status = 1" +
" where TemplateNo=" + pttemp.TemplateNo +
" and TemplateDate='" + pttemp.TemplateDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductTestTemplateHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertFinancialLimit(financiallimit flim)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into EmployeeFinancialLimit (DocumentID,EmployeeID,FinancialLimit,Status,CreateTime,CreateUser)" +
"values (" +
"'" + flim.DocumentID + "'," +
"'" + flim.EmployeeID + "'," +
flim.FinancialLimit + "," +
flim.DocumentStatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "EmployeeFinancialLimit", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
////////public Boolean checkEmployeeFinancialLimit(string docID, string empID, double ProductValue, double TaxAmount)
////////{
//////// Boolean status = false;
//////// double amt = 0;
//////// try
//////// {
//////// SqlConnection conn = new SqlConnection(Login.connString);
//////// string query = "select FinancialLimit " +
//////// "from EmployeeFinancialLimit where DocumentID='" + docID + "' and EmployeeID='" + empID + "' and Status=1";
//////// SqlCommand cmd = new SqlCommand(query, conn);
//////// conn.Open();
//////// SqlDataReader reader = cmd.ExecuteReader();
//////// if (reader.Read())
//////// {
//////// amt = reader.GetDouble(0);
//////// }
//////// conn.Close();
//////// if (amt >= ProductValue)
//////// {
//////// status = true;
//////// }
//////// }
//////// catch (Exception ex)
//////// {
//////// MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
//////// status = false;
//////// }
//////// return status;
////////}
public Boolean insertSefChecklist(sefcheck flim)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into SEFCheckList (SEFID,SequenceNo,Description,Status,CreateTime,CreateUser)" +
"values (" +
"'" + flim.SEFID + "'," +
"'" + flim.Sequenceno + "','" +
flim.description + "','" +
flim.Status + "'," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "SEFCheckList", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
