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); }