public Boolean insertMaterialDetail(materialdelivery mdd)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into MaterialDeliveryDetail " +
"(DeliveryDocumentType,DocumentNo,DocumentDate,Consignee,CourierID,TransportationMode,LRNo,LRDate," +
"DeliveryDate,DeliveryStatus,Remarks,Status,CreateTime,CreateUser)" +
" values (" +
"'" + mdd.DocumentType + "'," +
"'" + mdd.DocumentNo + "'," +
"'" + mdd.DocumentDate.ToString("yyyy-MM-dd") + "','" +
mdd.consignee + "'," +
"'" + mdd.courierID + "'," +
"'" + mdd.transportationMode + "'," +
"'" + mdd.LRNo + "'," +
"'" + mdd.LRDate.ToString("yyyy-MM-dd") + "'," +
"'" + mdd.DeliveryDate.ToString("yyyy-MM-dd") + "'," +
"'" + mdd.DeliveryStatus + "'," +
"'" + mdd.Remarks + "'," +
mdd.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "MaterialDeliveryDetail", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertStockOBHeader(stockobheader sobh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into StockOBHeader " +
"(DocumentID,FYID,TemporaryNo,Value,TemporaryDate,DocumentNo,DocumentDate,StoreLocation,Status,DocumentStatus," +
"CreateTime,CreateUser,ForwardUser,ApproveUser,Remarks)" +
"values (" +
"'" + sobh.DocumentID + "'," +
"'" + sobh.FYID + "'," +
sobh.TemporaryNo + "," +
sobh.Value + "," +
"GETDATE()" + "," +
"0,null," +
"'" + sobh.StoreLocation + "'," +
sobh.status + "," +
sobh.Documentstatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'," +
"'',''," +
"'" + sobh.Remarks + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "StockOBHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertMovementReg(movementregister mr)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into MovementRegister " +
" (EmployeeID,ExitTimePlanned,ReturnTimePlanned,Purpose,ModeOfTravel,Comments," +
"Approver,Status,DocumentStatus,CreateUser, CreateTime)" +
"values (" +
"'" + mr.EmployeeID + "'," +
"'" + mr.ExitTimePlanned.ToString("yyyy-MM-dd HH:mm:ss") + "'," +
"'" + mr.ReturnTimePlanned.ToString("yyyy-MM-dd HH:mm:ss") + "'," +
"'" + mr.Purpose + "'," +
"'" + mr.ModeOfTravel + "'," +
"'" + mr.Comments.Replace("'", "''") + "'," +
"'" + mr.ApproveUser + "'," +
mr.Status + "," +
mr.DocumentStatus + "," +
"'" + Login.userLoggedIn + "'," +
"GETDATE())";
//"'" + pheader.ForwardUser + "'," +
//"'" + pheader.ApproveUser + "'," +
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "MovementRegister", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateDocForClose(DocClose du)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update " + du.TableName + " set Status= 7 where RowID = " + du.RowID + "";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", 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 updateCustomerBankDetails(string customeRowid, List <customerbankdetails> cbdList)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "Delete from CustomerBankDetail where CustomerRowID='" + customeRowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "CustomerBankDetail", "", updateSQL) +
Main.QueryDelimiter;
foreach (customerbankdetails cbd in cbdList)
{
updateSQL = "insert into CustomerBankDetail (CustomerRowID,BankBranch,AccountNo,Status,CreateTime,CreateUser)" +
"values (" +
"'" + cbd.CustomerRowID + "'," +
"" + cbd.BankBranch + "," +
"'" + cbd.AccountNo + "'," +
cbd.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "CustomerBankDetail", "", 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 ReturnGatePass(gatepassheader gtnh, List <gatepassdetail> gplist)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update InventoryGatepassHeader set ReturnStatus=" + (gtnh.ReturnStatus + 1) +
" where DocumentID='" + gtnh.DocumentID + "'" +
" and TemporaryNo=" + gtnh.TemporaryNo +
" and TemporaryDate='" + gtnh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "InventoryGatepassHeader", "", updateSQL) +
Main.QueryDelimiter;
foreach (gatepassdetail gtnd in gplist)
{
updateSQL = "update InventoryGatepassDetail " +
"set QuantityReturning = " + gtnd.ReturningQuantity +
" where RowID = " + gtnd.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "InventoryGatepassDetail", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateInspectionStatusOfItem(productservicereportheader psrh)
{
Boolean status = true;
string updateSQL = "";
string utString = "";
try
{
if (psrh.ReportType == 1)
{
updateSQL = "update SMRNDetail set InspectionStatus=1 " +
" where JobIDNo= " + psrh.jobIDNo +
" and TemporaryNo=" + psrh.SMRNHeaderTempNo +
" and TemporaryDate='" + psrh.SMRNHeaderTempDate.ToString("yyyy-MM-dd") + "'";
}
else if (psrh.ReportType == 2)
{
updateSQL = "update SMRNDetail set ServiceStatus=1 " +
" where JobIDNo= " + psrh.jobIDNo +
" and TemporaryNo=" + psrh.SMRNHeaderTempNo +
" and TemporaryDate='" + psrh.SMRNHeaderTempDate.ToString("yyyy-MM-dd") + "'";
}
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "SMRNDetail", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean MoveTapal(string userID, tapalDistribution tap)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update TapalDistribution set Status = 1" +
" where RowID=" + tap.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "TapalDistribution", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = updateSQL = "insert into TapalDistribution " +
"(DocumentID, TapalReference, UserID, Date, Status,CreateTime,CreateUser) " +
"values ('" + tap.DocumentID + "',"
+ tap.TapalReference + ",'" +
userID + "','" +
tap.Date.ToString("yyyy-MM-dd") + "'," +
tap.Status + "," +
"GETDATE()" + ",'" +
Login.userLoggedIn + "')";
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(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(status);
}
public Boolean updateDocForUnlockingInvoiceIN(DocUnlock du, int docStat, string docID)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update " + du.TableName +
" set Status = 96,ApproveUser=NULL,DocumentStatus= " + docStat +
" where TemporaryNo = " + du.TemporaryNo +
" and TemporaryDate = '" + du.TemporaryDate.ToString("yyyy-MM-dd") + "' and DocumentID = '" + docID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", updateSQL) +
Main.QueryDelimiter;
//Updating PJVHeader
updateSQL = "update PJVHeader " +
" set Status = 96,ApproveUser=NULL,DocumentStatus= 1" +
" where InvTempNo = " + du.TemporaryNo +
" and InvTempDate = '" + du.TemporaryDate.ToString("yyyy-MM-dd") + "' and InvDocumentID = '" + docID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "PJVHeader", "", updateSQL) +
Main.QueryDelimiter;
//return false;
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 ApproveStockOB(stockobheader sobh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update StockOBHeader set DocumentStatus=99, status=1 " +
", ApproveUser='******'" +
", DocumentNo=" + sobh.DocumentNo +
", DocumentDate=GETDATE()" +
" where DocumentID='" + sobh.DocumentID + "'" +
" and TemporaryNo=" + sobh.TemporaryNo +
" and FYID='" + sobh.FYID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "StockOBHeader", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "update StockOBDetail set DocumentStatus=99 " +
" where DocumentID='" + sobh.DocumentID + "'" +
" and TemporaryNo=" + sobh.TemporaryNo +
" and FYID='" + sobh.FYID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "StockOBDetail", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean InsertDocumentDetails(documentStorage ds)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into DocumentStorage " +
"(DocumentID,DocumentSubID,Directory,FileName,Description,DocumentContent,ProtectionLevel,FileType,LastUploadedUser,LastUploadedTime,CreateUser,CreateTime)" +
" values (" +
"'" + ds.DocumentID + "'," +
"'" + ds.DocumentSubID + "'," +
"'" + ds.Directory + "'," +
"'" + ds.FileName + "'," +
"'" + ds.Description + "'," +
"'" + ds.DocumentContent + "'," +
ds.ProtectionLevel + "," +
"'" + ds.FileType + "'," +
"'" + Login.userLoggedIn + "'," + "GETDATE()," +
"'" + Login.userLoggedIn + "'," + "GETDATE()" + ")";
ds.DocumentContent = "";
//utString = utString + updateSQL + Main.QueryDelimiter;
//updateSQL = "";
////utString = utString +
////ActivityLogDB.PrepareActivityLogQquerString("insert", "DocumentStorage", "", updateSQL) +
////Main.QueryDelimiter;
if (!UpdateTable.UTSingleQuery(updateSQL))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean insertAccountCodeDetails(accountcode accode)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into AccountCode " +
" (AccountCode,Name,GroupLevel1,GroupLevel2,GroupLevel3,GroupLevel4,GroupLevel5,Status,DocumentStatus,CreateTime,CreateUser,ForwarderList)" +
"values (" +
"IDENT_CURRENT('AccountCode')" +
",'" + accode.Name + "'," +
"'" + accode.GroupLevel1 + "'," +
"'" + accode.GroupLevel2 + "'," +
"'" + accode.GroupLevel3 + "'," +
"'" + accode.GroupLevel4 + "'," +
"'" + accode.GroupLevel5 + "'," +
accode.status + "," +
accode.documentStatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" +
",'" + accode.ForwarderList + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "AccountCode", "", 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 Delfryear(int year)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "delete from LeaveOB where Year='" + year + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "LeaveOB", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public static Boolean deleteTapal(int rowid)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "delete TapalStorage where RowID=" + rowid;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "TapalStorage", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean DeleteTermsAndConditionsrow(int rowid)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "Delete from TermsAndCondition where RowID=" + rowid;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "TermsAndConditions", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public Boolean insertBankBranch(bankbranch branch)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into BankBranch (BankID,BranchName,Address1,Address2,Address3,IFSCCode,SWIFTCode,MICRCOde,BSRCode,Status,CreateTime,CreateUser)" +
"values (" +
"'" + branch.BankID + "'," +
"'" + branch.BranchName + "'," +
"'" + branch.Address1 + "'," +
"'" + branch.Address2 + "'," +
"'" + branch.Address3 + "'," +
"'" + branch.IFSCCode + "'," +
"'" + branch.SWIFTCode + "'," +
"'" + branch.MICRCode + "'," +
"'" + branch.BSRCode + "'," +
branch.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "BankBranch", "", 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 ApproveLeaveRequestCOmpoff(leaveapprove lv, int tp)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
updateSQL = "update LeaveRequest set Remarks='" + lv.remarks + "', " +
" SanctionedFromDate = '" + lv.sanctionedFrom.ToString("yyyy-MM-dd") + "', SanctionedToDate ='" + lv.sanctionedTo.ToString("yyyy-MM-dd") + "'," +
"documentstatus=99, ApproveUser='******', ApproveTime=GetDate() " +
"where RowID='" + lv.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "LeaveRequest", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "update LeaveEarning set Status=2 where RowID in" +
" (select top " + tp + " rowid from LeaveEarning where " +
" EmployeeID='" + lv.EmployeeID + "' and LeaveID='CO' and Status=1)";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "LeaveEarning", "", 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 insertProductModel(productmodels pmodel)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into ProductModel " +
" (ModelNo,ModelName,StockItemID,Remarks," +
"DocumentStatus,Status,CreateUser,CreateTime,ForwarderList)" +
"values (" +
"'0'," +
"'" + pmodel.ModelName + "'," +
"'" + pmodel.StockItemID + "'," +
"'" + pmodel.Remarks + "'," +
pmodel.DocumentStatus + "," +
pmodel.Status + "," +
"'" + Login.userLoggedIn + "'," +
"GETDATE()" +
",'" + pmodel.ForwarderList + "')";
//"'" + pheader.ForwardUser + "'," +
//"'" + pheader.ApproveUser + "'," +
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertLeaveyearOBDetail(List <leaveob> lobList, int year)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
foreach (leaveob lob in lobList)
{
if (lob.LeaveCount > 0 || lob.LeaveID == "LOP")
{
updateSQL = "insert into LeaveOB (EmployeeID,LeaveID,Year,LeaveCount,CreateTime,CreateUser)" +
"values (" +
"'" + lob.EmployeeID + "'," +
"'" + lob.LeaveID + "','" +
+year + "'," +
"'" + lob.LeaveCount + "'," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "LeaveOB", "", updateSQL) +
Main.QueryDelimiter;
}
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertStockItem(stockitem3 sitem)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into StockItem " +
" (StockItemID,Name,Reorderlevel,Level1GCode,Level2GCode,Level3GCode,Unit,Status,DocumentStatus,CreateTime,CreateUser,ForwarderList,HSNCode)" +
"values (" +
"IDENT_CURRENT('StockItem')" +
",'" + sitem.Name + "'," +
sitem.ReorderLevel + "," +
"'" + sitem.Group1Code + "'," +
"'" + sitem.Group2Code + "'," +
"'" + sitem.Group3Code + "'," +
"'" + sitem.Unit + "'," +
sitem.status + "," +
sitem.documentStatus + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" +
",'" + sitem.ForwarderList + "','" + sitem.HSNCode + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "StockItem", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean DeleteLeaveCompOff(int rowid)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
updateSQL = "update LeaveEarning set Status=4 where RowID='" + rowid + "' ";
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 static Boolean deleteDocument(int rowid)
{
Boolean stat = true;
string utString = "";
try
{
string updateSQL = "Delete from DocumentStorage where RowID= " + rowid;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "DocumentStorage", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
stat = false;
MessageBox.Show("Failed to delete.");
}
}
catch (Exception ex)
{
stat = false;
}
return(stat);
}
public Boolean insertDashboardAlarm(dashboardalarm dba)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into DashboardAlarm (DocumentID,TemporaryNo,TemporaryDate,DocumentNo,DocumentDate," +
"ActivityType,Details,FromUser,ToUser)" +
"values (" +
"'" + dba.DocumentID + "'," +
dba.TemporaryNo + "," +
"'" + dba.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
dba.DocumentNo + "," +
"'" + dba.DocumentDate.ToString("yyyy-MM-dd") + "'," +
dba.ActivityType + "," +
"'" + dba.Details + "'," +
"'" + Login.userLoggedIn + "'," +
"'" + dba.ToUser + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "DashboardAlarm", "", 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 CancelComplaintByUser(workplacecr wp)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update WorkplaceCR set Status = 4,Remarks = '" + wp.Remarks + "'" +
" where EmployeeID='" + wp.EmployeeID + "' and ID = " + wp.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "WorkplaceCR", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean RejectComplaintRegByMO(workplacecr wp)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update WorkplaceCR set Status = 3,CloseTime = GETDATE(),DocumentStatus = 2,Remarks = '" + wp.Remarks + "'" +
" where EmployeeID='" + wp.EmployeeID + "' and ID = " + wp.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "WorkplaceCR", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertComplaintReg(workplacecr wp)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into WorkplaceCR " +
" (EmployeeID,ComplaintType,ComplaintDescription,Remarks," +
"Status,DocumentStatus,CreateUser, CreateTime)" +
"values (" +
"'" + wp.EmployeeID + "'," +
// "'" + mr.ExitTimePlanned.ToString("yyyy-MM-dd HH:mm:ss") + "'," +
//"'" + mr.ReturnTimePlanned.ToString("yyyy-MM-dd HH:mm:ss") + "'," +
"'" + wp.ComplaintType + "'," +
"'" + wp.ComplaintDescription + "'," +
"'" + wp.Remarks + "'," +
wp.Status + "," +
wp.DocumentStatus + "," +
"'" + Login.userLoggedIn + "'," +
"GETDATE())";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "WorkplaceCR", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updateUserMenuPrivilege(usermenuprivilege mp)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update MenuPrivilege set MenuItemString='" + mp.menuItemString +
"' where UserID='" + mp.userID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "MenuPrivilege", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean UpdateLeaveOfficeMapping(Leave leavesett)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "Update LeaveOfficeMapping set MaxDays='" + leavesett.MaxDays + "',OfficeID='" + leavesett.officeID + "' where LeaveID='" + leavesett.leaveID + "'and RowID='" + leavesett.rowid + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "LeaveSanctionLimit", "", 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 LockFinancialYear(string fyID)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update FinancialYear set documentstatus = 99";
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 updatePRHeader(purchasereturnheader prh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update PurchaseReturnHeader set CustomerID='" + prh.CustomerID +
"',MRNNo='" + prh.MRNNo +
"',MRNDate='" + prh.MRNDate.ToString("yyyy-MM-dd") +
"', ProductValue='" + prh.ProductValue +
"', TaxAmount='" + prh.TaxAmount +
"', PurchaseReturnValue='" + prh.PRValue +
"', Remarks='" + prh.Remarks +
"', Comments='" + prh.Comments +
"', 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);
}
