protected void txtCustomerUsername_OnTextChanged(object sender, EventArgs e) { objSaleLedger = new SaleLedger(); objSaleLedgerBiz = new SaleLedgerBiz(); objSaleLedger = objSaleLedgerBiz.GetSaleLedgerInfoByCustomerUsername(txtCustomerUsername.Text.Trim()); txtSaleLedgerInvoiceNumber.Text = objSaleLedger.InvoiceNumber; txtCurrentDue.Text = objSaleLedger.CurrentDue.ToString(); Session["CustomerId"] = objSaleLedger.CustomerId.ToString(); }
protected void btnSubmitSaleLedgerDetails_Click(object sender, EventArgs e) { objSaleLedger = new SaleLedger(); objSaleLedgerBiz = new SaleLedgerBiz(); objSaleLedger.CustomerId = Convert.ToInt32(Session["CustomerId"]); objSaleLedger.InvoiceNumber = txtSaleLedgerInvoiceNumber.Text; objSaleLedger.TransactionType = Convert.ToByte(ddlReceivingType.SelectedValue); objSaleLedger.ReceivedAmount = Convert.ToDecimal(txtReceivedAmount.Text); objSaleLedger.CurrentDue = Request.Form[txtCurrentDue.UniqueID] != "" ? Convert.ToDecimal(Request.Form[txtCurrentDue.UniqueID]) : 0; objSaleLedger.TotalBalance = Request.Form[txtTotalBalance.UniqueID] != "" ? Convert.ToDecimal(Request.Form[txtTotalBalance.UniqueID]) : 0; objSaleLedger.CreatedBy = Convert.ToInt16(Session["UserId"].ToString()); MessageBox(objSaleLedgerBiz.CreateSaleLedger(objSaleLedger)); Session.Remove("CustomerId"); ClearInputs(Controls); }
public SaleLedger GetSaleLedgerInfoByCustomerUsername(string searchText) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; SaleLedger objSaleLedger = new SaleLedger(); List <SaleLedger> objPurchaseLedgerList = new List <SaleLedger>(); try { objDbCommand.AddInParameter("SearchText", searchText); objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[rdb].[uspGetSingleCustomerDetailForSL]", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { objSaleLedger = new SaleLedger(); this.BuildModelForSaleLedger(objDbDataReader, objSaleLedger); objPurchaseLedgerList.Add(objSaleLedger); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objSaleLedger); }
public string CreateSaleLedger(SaleLedger objSaleLedger) { int noOfAffacted = 0; objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable); objDbCommand.AddInParameter("CustomerId", objSaleLedger.CustomerId); objDbCommand.AddInParameter("InvoiceNumber", objSaleLedger.InvoiceNumber); objDbCommand.AddInParameter("TransactionType", objSaleLedger.TransactionType); objDbCommand.AddInParameter("ReceivedAmount", objSaleLedger.ReceivedAmount); objDbCommand.AddInParameter("CurrentDue", objSaleLedger.CurrentDue); objDbCommand.AddInParameter("TotalBalance", objSaleLedger.TotalBalance); objDbCommand.AddInParameter("CreatedBy", objSaleLedger.CreatedBy); try { noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "[rdb].[uspCreateSaleLedger]", CommandType.StoredProcedure); if (noOfAffacted > 0) { objDbCommand.Transaction.Commit(); return("Save Successful"); } else { objDbCommand.Transaction.Rollback(); return("Save Failed"); } } catch (Exception ex) { objDbCommand.Transaction.Rollback(); throw new Exception("Database Error Occured", ex); } finally { objDataAccess.Dispose(objDbCommand); } }
private void BuildModelForSaleLedger(DbDataReader objDataReader, SaleLedger objSaleLedger) { DataTable objDataTable = objDataReader.GetSchemaTable(); foreach (DataRow dr in objDataTable.Rows) { String column = dr.ItemArray[0].ToString(); switch (column) { case "SaleLedgerId": if (!Convert.IsDBNull(objDataReader["SaleLedgerId"])) { objSaleLedger.SaleLedgerId = Convert.ToInt16(objDataReader["SaleLedgerId"]); } break; case "CustomerId": if (!Convert.IsDBNull(objDataReader["CustomerId"])) { objSaleLedger.CustomerId = Convert.ToInt16(objDataReader["CustomerId"]); } break; case "InvoiceNumber": if (!Convert.IsDBNull(objDataReader["InvoiceNumber"])) { objSaleLedger.InvoiceNumber = Convert.ToString(objDataReader["InvoiceNumber"].ToString()); } break; case "TransactionType": if (!Convert.IsDBNull(objDataReader["TransactionType"])) { objSaleLedger.TransactionType = Convert.ToByte(objDataReader["TransactionType"].ToString()); } break; case "ReceivedAmount": if (!Convert.IsDBNull(objDataReader["ReceivedAmount"])) { objSaleLedger.ReceivedAmount = Convert.ToDecimal(objDataReader["ReceivedAmount"].ToString()); } break; case "CurrentDue": if (!Convert.IsDBNull(objDataReader["CurrentDue"])) { objSaleLedger.CurrentDue = Convert.ToDecimal(objDataReader["CurrentDue"].ToString()); } break; case "TotalBalance": if (!Convert.IsDBNull(objDataReader["TotalBalance"])) { objSaleLedger.TotalBalance = Convert.ToDecimal(objDataReader["TotalBalance"].ToString()); } break; case "CustomerUsername": if (!Convert.IsDBNull(objDataReader["CustomerUsername"])) { objSaleLedger.CustomerUsername = objDataReader["CustomerUsername"].ToString(); } break; case "IsActive": if (!Convert.IsDBNull(objDataReader["IsActive"])) { objSaleLedger.IsActive = Convert.ToBoolean(objDataReader["IsActive"].ToString()); } break; case "CreatedBy": if (!Convert.IsDBNull(objDataReader["CreatedBy"])) { objSaleLedger.CreatedBy = Convert.ToInt16(objDataReader["CreatedBy"]); } break; case "CreatedDate": if (!Convert.IsDBNull(objDataReader["CreatedDate"])) { objSaleLedger.CreatedDate = Convert.ToDateTime(objDataReader["CreatedDate"].ToString()); } break; case "UpdatedBy": if (!Convert.IsDBNull(objDataReader["UpdatedBy"])) { objSaleLedger.UpdatedBy = Convert.ToInt16(objDataReader["UpdatedBy"].ToString()); } break; case "UpdatedDate": if (!Convert.IsDBNull(objDataReader["UpdatedDate"])) { objSaleLedger.UpdatedDate = Convert.ToDateTime(objDataReader["UpdatedDate"].ToString()); } break; case "SortedBy": if (!Convert.IsDBNull(objDataReader["SortedBy"])) { objSaleLedger.SortedBy = Convert.ToByte(objDataReader["SortedBy"].ToString()); } break; case "Remarks": if (!Convert.IsDBNull(objDataReader["Remarks"])) { objSaleLedger.Remarks = objDataReader["Remarks"].ToString(); } break; default: break; } } }