public Boolean insertUser(user usr)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into ERPUser (UserID,Password,EmployeeID,Type,Status,CreateTime,CreateUser)" +
"values (" +
"'" + usr.userID + "'," +
"'" + usr.userPassword + "'," +
usr.userEmpID + "," +
usr.userType + "," +
usr.userStatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ERPUser", "", 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 updateCatalogue(catalogue cat)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update Catalogue set Description='" + cat.description +
"',Status=" + cat.status +
" where CatalogueID='" + cat.catalogueID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "Catalogue", "", 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 insertDocEmpMapping(docempmapping doc)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into DocEmpMapping (DocumentID,EmployeeID,SeniorEmployeeID,Status,CreateTime,CreateUser)" +
"values (" +
"'" + doc.DocumentID + "'," +
"'" + doc.EmployeeID + "'," +
"'" + doc.SeniorEmployeeID + "'," +
doc.DocumentStatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "DocEmpMapping", "", 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 updateAccountDayBookDetail(accountdaybook adb)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update AccountDayBookCode set BookType='" + adb.BookType +
"',Status=" + adb.status +
" where AccountCode='" + adb.AccountCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "AccountDayBookCode", "", 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 insertCompAddress(companyaddress ca)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into CompanyAddress (CompanyID,AddressType,Address," +
"Status,CreateTime,CreateUser)" +
" values (" +
ca.CompanyID + "," +
ca.AddressType + "," +
"'" + ca.Address + "'," +
ca.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "CompanyAddress", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateMovementReg(movementregister mr, movementregister prevmr)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update MovementRegister set ExitTimePlanned ='" + mr.ExitTimePlanned.ToString("yyyy-MM-dd HH:mm:ss") + "'" +
", ReturnTimePlanned ='" + mr.ReturnTimePlanned.ToString("yyyy-MM-dd HH:mm:ss") +
"', ModeOfTravel ='" + mr.ModeOfTravel +
"', Comments ='" +
mr.Comments.Replace("'", "''") +
"', Approver='" + mr.ApproveUser +
"', Purpose='" + mr.Purpose +
"' where EmployeeID='" + prevmr.EmployeeID + "' and RowID = " + prevmr.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "MovementRegister", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean reverseQI(qiheader qih)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update QIHeader set DocumentStatus=" + qih.DocumentStatus +
", forwardUser='******'" +
", commentStatus='" + qih.CommentStatus + "'" +
", ForwarderList='" + qih.ForwarderList + "'" +
" where DocumentID='" + qih.DocumentID + "'" +
" and TemporaryNo=" + qih.TemporaryNo +
" and TemporaryDate='" + qih.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "QIHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ChangeTapalStatus(int rowID, int tapalStatus)
{
Boolean status = true;
string utString = "";
try
{
//if tapalstatus=2 and existing status is not 3, then change status to 4
if (tapalStatus == 2)
{
//for deletion
if (getPresenetStatus(rowID) != 3)
{
//deletion without viewing
tapalStatus = 4;
}
}
string updateSQL = "update TapalDistribution set Status = " + tapalStatus +
" where RowID=" + rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "TapalDistribution", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(status);
}
public Boolean updateTapalDetails(tapal tap, int rowid)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update TapalStorage set" +
" InwardDocumentType='" + tap.InwardDocumentType + "', " +
"ReceivedFrom='" + tap.ReceivedFrom + "'," +
" Description='" + tap.Description + "' " +
"where RowID='" + rowid + "'";
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 ApproveCreditNoteHeader(CreditNoteHeader cnh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update CreditNoteHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", commentStatus='" + cnh.CommentStatus + "'" +
", CreditNoteNo =" + cnh.CreditNoteNo +
", CreditNoteDate=convert(date, getdate())" +
" where DocumentID='" + cnh.DocumentID + "'" +
" and TemporaryNo=" + cnh.TemporaryNo +
" and TemporaryDate='" + cnh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "CreditNoteHeader", "", 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 updateTapalStatus(tapal tap)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update TapalStorage set Status = 1" +
" where RowID=" + tap.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "TapalStorage", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(status);
}
public Boolean insertEmployeePosting(employeeposting empposting)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into EmployeePosting (EmployeeID,PostingDate,OfficeID,Department,ReportingOfficerID,Remarks,Status,CreateTime,CreateUser) values (" +
"'" + empposting.empID + "'," +
"'" + (empposting.postingDate.ToString("yyyyMMdd")) + "'," +
"'" + empposting.officeID + "'," +
"'" + empposting.departmentID + "'," +
"'" + empposting.ReportingOfficer + "'," +
"'" + empposting.remarks + "'," +
empposting.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "EmployeePosting", "", 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 updateEmployee(employee emp)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update Employee set name='" + emp.empName + "',DOB='" +
(emp.empDOB.ToString("yyyyMMdd HH:mm:ss")) +
"',DOJ='" + (emp.empDOJ.ToString("yyyyMMdd HH:mm:ss")) +
"',phoneno='" + emp.empPhoneNo + "',Status=" + emp.empStatus +
////",Photo='" + emp.empPhoto + "'" +
" where EmployeeID='" + emp.empID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "Employee", "", 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 static Boolean updateEmpPosting(string rowid, employeeposting empPost)
{
Boolean status = true;
string utString = "";
try
{
SqlConnection con = new SqlConnection(Login.connString);
string query = "update EmployeePosting set" +
" PostingDate='" + (empPost.postingDate.ToString("yyyyMMdd")) + "'," +
" OfficeID='" + empPost.officeID + "'," +
" Department='" + empPost.departmentID + "'," +
" Remarks='" + empPost.remarks + "'," +
" Status=" + empPost.Status +
" , ReportingOfficerID = '" + empPost.ReportingOfficer + "'" +
" where RowID=" + rowid + "";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
//cmd.Parameters.Add("@emp.empPicture", emp.empPicture);
utString = utString + query + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "EmployeePosting", "", query) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean reverseBOM(bomheader bomh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update BOMHeader set DocumentStatus=" + bomh.DocumentStatus +
", forwardUser='******'" +
", commentStatus='" + bomh.CommentStatus + "'" +
", ForwarderList='" + bomh.ForwarderList + "'" +
" where ProductID='" + bomh.ProductID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "BOMHeader", "", 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 FinalizePSR(productservicereportheader psrh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductServiceReportHeader set status=1 " +
", ReportNo=" + psrh.ReportNo +
", ReportDate = convert(date, getdate())" +
" where DocumentID='" + psrh.DocumentID + "'" +
" and TemporaryNo=" + psrh.TemporaryNo +
" and TemporaryDate='" + psrh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductServiceReportHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveBOM(bomheader bomh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update BOMHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", commentStatus='" + bomh.CommentStatus + "'" +
", ReworkDate = convert(date, getdate())" +
" where ProductID='" + bomh.ProductID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "BOMHeader", "", 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 updateProductModels(productmodels pmodel, productmodels prevpmodel)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductModel set ModelDetails='" + pmodel.ModelName + "'" +
", StockItemID='" + pmodel.StockItemID +
"', Remarks ='" + pmodel.Remarks +
"', ForwarderList='" + pmodel.ForwarderList +
"' where RowID=" + prevpmodel.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveMR(movementregister mr)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update MovementRegister set DocumentStatus=2, Comments='" + mr.Comments + "'" +
", ApproveTime = GETDATE() " +
", Approver='" + Login.userLoggedIn + "'" +
" where employeeID='" + mr.EmployeeID + "' and RowID = " + mr.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "MovementRegister", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean reverseProductModel(productmodels prevpmodel)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductModel set DocumentStatus=" + prevpmodel.DocumentStatus +
", forwardUser='******'" +
", ForwarderList='" + prevpmodel.ForwarderList + "'" +
" where StockItemID='" + prevpmodel.StockItemID + "'" +
" and RowID = " + prevpmodel.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveQI(qiheader qih)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update QIHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", commentStatus='" + qih.CommentStatus + "'" +
", DocumentNo=" + qih.DocumentNo +
", DocumentDate = convert(date, getdate())" +
" where DocumentID='" + qih.DocumentID + "'" +
" and TemporaryNo=" + qih.TemporaryNo +
" and TemporaryDate='" + qih.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "QIHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean ApproveProductModel(productmodels pmodel, string modelNo)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductModel set DocumentStatus=99" +
", Status=1" +
", ModelNo='" + modelNo + "'" +
", ApproveUser='******'" +
" where StockItemID='" + pmodel.StockItemID + "'" +
" and RowID = " + pmodel.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertAccountDayBookDetail(accountdaybook adb)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into AccountDayBookCode (AccountCode,BookType,Status,CreateTime,CreateUser)" +
" values (" +
"'" + adb.AccountCode + "'," +
"'" + adb.BookType + "'," +
adb.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "AccountDayBookCode", "", 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 insertHSNCOde(HSNMapping map)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into ProductHSNMapping (StockItemID,ModelNo,HSNCode,Status,CreateTime,CreateUser)" +
" values (" +
"'" + map.StockItemID + "'," +
"'" + map.ModelNo + "'," +
"'" + map.HSNCode + "'," +
map.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductHSNMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateCompAddress(companyaddress ca)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update CompanyAddress set AddressType = " + ca.AddressType +
" ,Address = '" + ca.Address.Replace("'", "''") + "',Status=" + ca.Status +
" where RowID=" + ca.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "CompanyAddress", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateHSNCode(HSNMapping map)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductHSNMapping set HSNCode='" + map.HSNCode +
"',Status=" + map.Status +
" where RowID=" + map.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductHSNMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertCatalogue(catalogue cat)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into Catalogue (catalogueID,Description,Status,CreateTime,CreateUser)" +
"values (" +
"'" + cat.catalogueID + "'," +
"'" + cat.description + "'," +
cat.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "Catalogue", "", 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 insertdetails(cmpnydetails det)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into CompanyDetail (CompanyID,CompanyName,Address,Status)" +
"values (" +
"'" + det.companyID + "'," +
"'" + det.companyname + "'," +
"'" + det.companyAddress + "'," +
"'" + det.status + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "CompanyDetail", "", 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 updateDocEmpMapping(docempmapping doc, docempmapping prevdoc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update DocEmpMapping set EmployeeID='" + doc.EmployeeID + "'," +
"SeniorEmployeeID='" + doc.SeniorEmployeeID + "'," +
" Status=" + doc.DocumentStatus +
" where DocumentID='" + prevdoc.DocumentID + "'" +
" and EmployeeID='" + prevdoc.EmployeeID + "'" +
" and SeniorEmployeeID='" + prevdoc.SeniorEmployeeID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "DocEmpMapping", "", 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 updateUserPassword(string userID, string Password)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ERPUser set Password='******'" +
" where UserID='" + userID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ERPUser", "", 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);
}