public bool AddUser() { bool bretval = false; strsql = "Insert into SystemUser (UserName,UserPassword,UserFullName,CreatedBy, Createddate)" + " Values ('" + UserName + "','" + Password + "','" + FullName + "'," + CreatedBy + ",GETDATE()"; try { db.ExecuteQuery(strsql, DBAccess.AUDIT); bretval = true; } catch (Exception ex) { bretval = false; } return(bretval); }
public void SaveAdvance(AdvanceMaster advmaster, LedgerTrnMaster master) { strsql = " INSERT INTO Advance_File( trDate,trMonth,PayMode,crAcc,drAcc,trRoute)" + " Values (CONVERT(DateTime,'" + String.Format("{0:yyyy-{0:mm}-{0:dd}", advmaster.trDate) + "',102 '" + String.Format("{0:MMM}- {0:yyyy}", advmaster.trDate) + "'," + "'" + advmaster.PayMode + "','" + advmaster.crAcc + "','" + advmaster.drAcc + "','" + advmaster.trRoute + "')"; db = new DBAccess(); db.ExecuteQuery(strsql, DBAccess.BoughtLeaf); SaveLedger(master); }
/// <summary> /// Saving details of the ledger as accounts transactions /// </summary> /// <param name="transaction"></param> public void SaveLedgerDetails(LedgerTransaction transaction) { strsql = " Insert Into Ac_Trans ( [trDate],[trNo],[trCode] ,[trCdeNo],[AcCode],[Debit],[Credit],[trMode], " + " [sTime], [ItemType],[ItemName],[ItemCode],[qtIn],[qtOut],[Rate] ,[ExpCode], " + " [CopCode],[LabourCR],[LabourCW] ,[InvNo],[TxVal],[CostID],[ExpSubCode],[CopMainCode],[ZynkeD]) " + " Values ( CONVERT(DateTime,'," + String.Format("{0:yyyy-{0:mm}-{0:dd}", transaction.trDate) + ",23)," + transaction.trNo + ",'" + transaction.trCode + "','" + transaction.trCdeNo + "','" + transaction.AcCode + "'," + transaction.Debit + "," + transaction.Credit + ",'" + transaction.trMode + "',GETDATE(),'" + transaction.ItemType + "'," + "'" + transaction.ItemName + "','" + transaction.ItemCode + "'," + transaction.qtIn + "," + transaction.qtOut + "," + transaction.Rate + "," + transaction.ExpCode + "," + transaction.CopCode + "," + transaction.LabourCR + "," + transaction.LabourCW + ",'" + transaction.InvNo + "'," + transaction.TxVal + ",'" + transaction.CostID + "'," + transaction.CopMainCode + "," + transaction.ZynkeD + ")"; db = new DBAccess(); db.ExecuteQuery(strsql, DBAccess.BoughtLeaf); }
//public void CommitSavingPayment(DataTable table) //{ // if (!TableExisits("SavingLedger")) // { // CreateSavingLedgerTable(); // } // Task task = DBAccess.ExecuteSavingTransaction(0, table); // task.Wait(); // //task. //} public void CreateSavingLedgerTable() { string sql = " CREATE TABLE SavingLedger (" + " RegNo int, RegName nchar(50), Route nchar(30),ItemName nchar(50), Amount money, Unit nchar(10), " + " ItemOrder int, Qty numeric(18,2),Maincategory nchar(10))"; try { DBAccess.ExecuteQuery(sql, DBAccess.BoughtLeaf); } catch (Exception ex) { throw ex; } //throw new NotImplementedException(); }
/// <summary> /// Saving Accounts Ledger /// </summary> /// <param name="trnMaster"></param> public void SaveLedger(LedgerTrnMaster trnMaster) { strsql = "Insert Into Ac_TrMain ( [TrID],[trType],[trDate],[Description],[PayeName],[ChequeNo],[PresentDate], " + " [CreditAcc],[DebitAcc],[Amount] ,[FormName],[RegNo],[CrMonth] ,[Route], " + " [myModule],[UserLog],[ListID] Values ('" + trnMaster.TrID + "','" + trnMaster.trType + "'," + " CONVERT( DateTime,'" + String.Format("{0:yyyy-{0:mm}-{0:dd}", trnMaster.trDate) + "',23)," + "'" + trnMaster.Description + "','" + trnMaster.PayeName + "','" + trnMaster.ChequeNo + "',NULL," + "'" + trnMaster.CreditAcc + "','" + trnMaster.DebitAcc + "'," + trnMaster.Amount + ",'" + trnMaster.FormName + "'," + trnMaster.RegNo + ",'" + trnMaster.CrMonth + "','" + trnMaster.Route + "','" + trnMaster.myModule + "','" + trnMaster.UserLog + "','" + trnMaster.ListID + "')"; db = new DBAccess(); db.ExecuteQuery(strsql, DBAccess.BoughtLeaf); foreach (LedgerTransaction ledger in trnMaster.ledgerTransactions) { SaveLedgerDetails(ledger); } }
/// <summary> /// Cash master entry /// </summary> /// <param name="cashnn"></param> /// <returns>Cash master object</returns> private CashNN InsertCashMaster(CashNN cashnn) { cashnn.ws = Environment.MachineName + DateTime.Now.ToShortTimeString().Trim(); strsql = "Insert into indCA Values ('" + cashnn.ws + "',GETDATE())"; db = new DBAccess(); db.ExecuteQuery(strsql, DBAccess.GL); //strsql = "Select top 1 * from indCA Order by Ind Desc"; //table = db.GetDataTable(strsql, DBAccess.GL); //if (table.Rows.Count == 1) //{ // cashnn.ind = int.Parse(table.Rows[0]["ind"].ToString()); // cashnn.ws = table.Rows[0]["ws"].ToString(); // cashnn.st = DateTime.Parse(table.Rows[0]["st"].ToString()); //} cashnn = GetCashLastNo(); return(cashnn); //throw new NotImplementedException(); }