private void MapObject(DueCollection oDueCollection, NullHandler oReader) { BusinessObject.Factory.SetID(oDueCollection, new ID(oReader.GetInt32("TrnID"))); oDueCollection.TrnRef = oReader.GetString("TrnRef"); oDueCollection.TranRefPrint = oReader.GetString("TranRefPrint"); oDueCollection.LegacyRef = oReader.GetString("LegacyRef"); oDueCollection.PartyType = (EnumParty)oReader.GetInt32("PartyType"); oDueCollection.AccountCode = oReader.GetString("AccountCode"); oDueCollection.PartyName = oReader.GetString("PartyName"); oDueCollection.TranLastDate = oReader.GetDateTime("TranLastDate"); oDueCollection.OutStdBalance = oReader.GetDouble("OutStdBalance"); oDueCollection.TotalBill = oReader.GetDouble("TotalBill"); oDueCollection.ReceivedBalance = oReader.GetDouble("PaidAmnt"); BusinessObject.Factory.SetObjectState(oDueCollection, ObjectState.Saved); }
private ItemOrder MapItemOrder(DbDataReader dr) { ItemOrder itemOrder = new ItemOrder(); itemOrder.OrderId = NullHandler.GetString(dr["OrderId"]); itemOrder.SrId = NullHandler.GetString(dr["SrId"]); itemOrder.MarketId = NullHandler.GetString(dr["MarketId"]); itemOrder.OrderDate = NullHandler.GetDateTime(dr["Date"]); itemOrder.OrderCount = NullHandler.GetInt32(dr["OrderCount"]); itemOrder.ReturnCount = NullHandler.GetInt32(dr["ReturnCount"]); itemOrder.DamageCount = NullHandler.GetInt32(dr["DamagedCount"]); itemOrder.SellsCount = NullHandler.GetInt32(dr["SoldCount"]); itemOrder.CompanyId = NullHandler.GetString(dr["CompanyId"]); itemOrder.ItemId = NullHandler.GetString(dr["ItemId"]); itemOrder.ItemName = NullHandler.GetString(dr["ItemName"]); itemOrder.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]); itemOrder.Price = NullHandler.GetDouble(dr["Price"]); itemOrder.TotalPrice = Math.Round(itemOrder.Price * itemOrder.SellsCount, 2); itemOrder.StockId = NullHandler.GetString(dr["StockId"]); itemOrder.CurrentStockTotal = NullHandler.GetInt32(dr["TotalStock"]); itemOrder.CurrentDamagedStockTotal = NullHandler.GetInt32(dr["DamagedStock"]); itemOrder.ChalanNo = NullHandler.GetString(dr["ChalanNo"]); itemOrder.StockEntryDate = NullHandler.GetDateTime(dr["StockEntryDate"]); itemOrder.CalculateBoxesFromTotalStock(); itemOrder.CalculateOrdersInBox(); return(itemOrder); }
/// <summary> /// Froms the reader. /// </summary> /// <param name="reader">The reader.</param> public virtual void FromReader(IDataReader reader) { ID = NullHandler.GetLong(reader["Id"]); IsActive = NullHandler.GetBoolean(reader["IsActive"]); IsDeleted = NullHandler.GetBoolean(reader["IsDeleted"]); IsLocked = NullHandler.GetBoolean(reader["IsLocked"]); SystemModstamp = NullHandler.GetDateTime(reader["SystemModstamp"]); }
private void MapObject(UserSecurity oUserSecurity, NullHandler oReader) { BusinessObject.Factory.SetID(oUserSecurity, new ID(oReader.GetInt32("USID"))); oUserSecurity.user_id = oReader.GetInt32("user_id"); oUserSecurity.MacAddress = oReader.GetString("MacAddress"); oUserSecurity.IsAuthorise = oReader.GetBoolean("IsAuthorise"); oUserSecurity.AuthoriseBy = oReader.GetInt32("AuthoriseBy"); oUserSecurity.RequestDate = oReader.GetDateTime("RequestDate"); oUserSecurity.AuthoriseDate = oReader.GetDateTime("AuthoriseDate"); BusinessObject.Factory.SetObjectState(oUserSecurity, ObjectState.Saved); }
private User Mapobject(DbDataReader dr) { User user = new User(); user.userID = NullHandler.GetString(dr["USER_ID"]); user.userName = NullHandler.GetString(dr["USER_NAME"]); user.password = NullHandler.GetString(dr["PASSWORD"]); user.creationDate = NullHandler.GetDateTime(dr["CREATION_DATE"]); user.roleType = (RoleType)NullHandler.GetInt32(dr["ROLE_TYPE"]); user.active = NullHandler.GetBoolean(dr["ACTIVE"]); return(user); }
private Chalan MapChalan(DbDataReader dr) { Chalan chalan = new Chalan(); chalan.ChalanId = NullHandler.GetString(dr["ChalanId"]); chalan.ChalanNo = NullHandler.GetString(dr["ChalanNo"]); chalan.ItemId = NullHandler.GetString(dr["ItemId"]); chalan.ItemName = NullHandler.GetString(dr["ItemName"]); chalan.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]); chalan.EntryCount = NullHandler.GetInt32(dr["EntryCount"]); chalan.ChalanDate = NullHandler.GetDateTime(dr["ChalanDate"]); chalan.CalculateBoxesFromTotalChalan(); return(chalan); }
private ItemStock MapStockItem(DbDataReader dr) { ItemStock stockItem = new ItemStock(); stockItem.CompanyId = NullHandler.GetString(dr["CompanyId"]); stockItem.ItemId = NullHandler.GetString(dr["ItemId"]); stockItem.ItemName = NullHandler.GetString(dr["ItemName"]); stockItem.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]); stockItem.StockId = NullHandler.GetString(dr["StockId"]); stockItem.CurrentStockTotal = NullHandler.GetInt32(dr["TotalStock"]); stockItem.CurrentDamagedStockTotal = NullHandler.GetInt32(dr["DamagedStock"]); stockItem.ChalanNo = NullHandler.GetString(dr["ChalanNo"]); stockItem.StockEntryDate = NullHandler.GetDateTime(dr["StockEntryDate"]); stockItem.CalculateBoxesFromTotalStock(); stockItem.CalculateBoxesFromDamagedTotalStock(); return(stockItem); }
private void MapObject(SaleOrderDetail oSaleOrderDetail, NullHandler oReader) { BusinessObject.Factory.SetID(oSaleOrderDetail, new ID(oReader.GetInt32("SaleID"))); oSaleOrderDetail.SONumber = oReader.GetString("SONumber"); oSaleOrderDetail.saleDate = oReader.GetDateTime("saleDate"); oSaleOrderDetail.PONumber = oReader.GetString("PONumber"); oSaleOrderDetail.printBillRef = oReader.GetString("printBillRef"); oSaleOrderDetail.memoNo = oReader.GetString("memoNo"); oSaleOrderDetail.Pro_ID = oReader.GetInt32("Pro_ID"); oSaleOrderDetail.discount = oReader.GetDouble("discount"); oSaleOrderDetail.newCus = oReader.GetString("newCus"); oSaleOrderDetail.newCusContact = oReader.GetString("newCusContact"); oSaleOrderDetail.PartyID = oReader.GetString("PartyID"); oSaleOrderDetail.prodUnit = oReader.GetString("prodUnit"); oSaleOrderDetail.bagQty = oReader.GetDouble("bagQty"); oSaleOrderDetail.unitPrice = oReader.GetDouble("unitPrice"); oSaleOrderDetail.unitPerBag = oReader.GetDouble("unitPerBag"); oSaleOrderDetail.transportCost = oReader.GetDouble("transportCost"); oSaleOrderDetail.returnQty = oReader.GetDouble("returnQty"); oSaleOrderDetail.totalSaleQty = oReader.GetDouble("totalSaleQty"); oSaleOrderDetail.totalAmount = oReader.GetDouble("totalAmount"); oSaleOrderDetail.comments = oReader.GetString("comments"); BusinessObject.Factory.SetObjectState(oSaleOrderDetail, ObjectState.Saved); }
private ItemOrder MapItemOrderTemplate(DbDataReader dr) { ItemOrder itemOrderTemplate = new ItemOrder(); itemOrderTemplate.OrderId = string.Empty; itemOrderTemplate.SrId = string.Empty; itemOrderTemplate.MarketId = string.Empty; itemOrderTemplate.OrderDate = DateTime.Now; itemOrderTemplate.OrderCount = 0; itemOrderTemplate.OrderBoxCount = 0; itemOrderTemplate.OrderExtraCount = 0; itemOrderTemplate.ReturnCount = 0; itemOrderTemplate.ReturnBoxCount = 0; itemOrderTemplate.ReturnExtraCount = 0; itemOrderTemplate.DamageCount = 0; itemOrderTemplate.DamageBoxCount = 0; itemOrderTemplate.DamageExtraCount = 0; itemOrderTemplate.SellsCount = 0; itemOrderTemplate.SellsBoxCount = 0; itemOrderTemplate.SellsExtraCount = 0; itemOrderTemplate.CompanyId = NullHandler.GetString(dr["CompanyId"]); itemOrderTemplate.ItemId = NullHandler.GetString(dr["ItemId"]); itemOrderTemplate.ItemName = NullHandler.GetString(dr["ItemName"]); itemOrderTemplate.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]); itemOrderTemplate.Price = NullHandler.GetDouble(dr["Price"]); itemOrderTemplate.StockId = NullHandler.GetString(dr["StockId"]); itemOrderTemplate.CurrentStockTotal = NullHandler.GetInt32(dr["TotalStock"]); itemOrderTemplate.CurrentDamagedStockTotal = NullHandler.GetInt32(dr["DamagedStock"]); itemOrderTemplate.ChalanNo = NullHandler.GetString(dr["ChalanNo"]); itemOrderTemplate.StockEntryDate = NullHandler.GetDateTime(dr["StockEntryDate"]); itemOrderTemplate.CalculateBoxesFromTotalStock(); //itemOrderTemplate.CalculateOrdersInBox(); return(itemOrderTemplate); }
private void MapObject(Transaction oTransaction, NullHandler oReader) { BusinessObject.Factory.SetID(oTransaction, new ID(oReader.GetInt32("TrnID"))); oTransaction.TranRef = oReader.GetString("TranRef"); oTransaction.LegacyRef = oReader.GetString("LegacyRef"); oTransaction.TranHead = oReader.GetString("TranHead"); oTransaction.CurrBalance = oReader.GetDouble("CurrBalance"); oTransaction.DrAmount = oReader.GetDouble("DrAmount"); oTransaction.CrAmount = oReader.GetDouble("CrAmount"); oTransaction.TranDate = oReader.GetDateTime("TranDate"); oTransaction.Perticular = oReader.GetString("Perticular"); BusinessObject.Factory.SetObjectState(oTransaction, ObjectState.Saved); }
private DetailPaymentInfo MapPayment(DbDataReader dr) { DetailPaymentInfo detailPaymentInfo = new DetailPaymentInfo(); detailPaymentInfo.PaymentId = NullHandler.GetString(dr["PaymentId"]); detailPaymentInfo.Id = NullHandler.GetString(dr["SrId"]); detailPaymentInfo.CompanyId = NullHandler.GetString(dr["CompanyId"]); detailPaymentInfo.PaymentDate = NullHandler.GetDateTime(dr["PaymentDate"]); detailPaymentInfo.ThousendCount = NullHandler.GetInt32(dr["ThousendCount"]); detailPaymentInfo.FiveHundredCount = NullHandler.GetInt32(dr["FiveHundredCount"]); detailPaymentInfo.OneHundredCount = NullHandler.GetInt32(dr["OneHundredCount"]); detailPaymentInfo.FiftyCount = NullHandler.GetInt32(dr["FiftyCount"]); detailPaymentInfo.TwentyCount = NullHandler.GetInt32(dr["TwentyCount"]); detailPaymentInfo.TenCount = NullHandler.GetInt32(dr["TenCount"]); detailPaymentInfo.FiveCount = NullHandler.GetInt32(dr["FiveCount"]); detailPaymentInfo.TwoCount = NullHandler.GetInt32(dr["TwoCount"]); detailPaymentInfo.OneCount = NullHandler.GetInt32(dr["OneCount"]); detailPaymentInfo.TotalPayment = NullHandler.GetDecimal(dr["TotalPayment"]); return(detailPaymentInfo); }
/// <summary> /// Binds a Dropdownlist Controls to a Collection /// </summary> /// <typeparam name="T"></typeparam> /// <param name="ddl"></param> /// <param name="entities"></param> /// <param name="displayField"></param> /// <param name="valueField"></param> //public static void BindDropDownList<T>(DropDownList ddl, IList<T> entities, String displayField, String valueField) // where T : BaseEntity //{ // if (entities == null || entities.Count == 0) // { // if (ddl.Items.Count > 0) // ddl.Items.Clear(); // ddl.DataSource = null; // ddl.DataBind(); // } // else // { // ddl.DataSource = entities; // ddl.DataTextField = displayField; // ddl.DataValueField = valueField; // ddl.DataBind(); // } // ddl.Items.Insert(0, new ListItem(String.Empty, String.Empty)); //} /// <summary> /// Binds a Dropdownlist to a DataTable /// </summary> /// <param name="ddl"></param> /// <param name="dt"></param> /// <param name="displayField"></param> /// <param name="valueField"></param> //public static void BindDropDownList(DropDownList ddl, DataTable dt, String displayField, String valueField) //{ // if (dt == null || dt.Rows.Count <= 0) // { // if (ddl.Items.Count > 0) // ddl.Items.Clear(); // ddl.DataSource = null; // ddl.DataBind(); // } // else // { // ddl.DataSource = dt.DefaultView; // ddl.DataTextField = displayField; // ddl.DataValueField = valueField; // ddl.DataBind(); // } // ddl.Items.Insert(0, new ListItem(String.Empty, String.Empty)); //} /// <summary> /// Adds Client Side Confirmation Text to a Server Side Button Control according to the Validation Group /// </summary> /// <param name="btn"></param> /// <param name="message"></param> /// <param name="isSaveButton"></param> //public static void AddCorfirmation(Button btn, String message, bool isSaveButton) //{ // if (isSaveButton) // { // if (!btn.ValidationGroup.IsNullOrEmpty()) // btn.Attributes.Add("ValidationGroupName", btn.ValidationGroup); // btn.Attributes.Add(AppConstants.CONFIRMATION_MSG_CUSTOM_ATTR, message); // btn.Attributes["onclick"] = "return ShowSaveConfirmation(this);"; // } // else // btn.Attributes["onclick"] = String.Format("return confirm('{0}');", message); //} /// <summary> /// Creates a Uniques UserID from Organization Code and UserID /// </summary> /// <param name="adminSystemUser"></param> /// <returns></returns> //public static string GetUserID(App.Models.Admin.AdminSystemUser adminSystemUser) //{ // return String.Format("{0}{1}", adminSystemUser.OrgCode, adminSystemUser.UserID); //} //public static String GetDeleteConfirmation() //{ // return String.Format("onclick=\"return confirm('Sure to Delete?')\""); //} //public static String GetEditPermissionDeniedMessage() //{ // return String.Format("javascript:alert('{0}');javascript:void(0);", AppConstants.Message.EDIT_PERMISSION_DENIED); //} //public static String GetDeletePermissionDeniedMessage() //{ // return String.Format("javascript:alert('{0}');javascript:void(0);", AppConstants.Message.DELETE_PERMISSION_DENIED); //} /// <summary> /// Returns Formatted Data Returned from a Data Reader or a Data Table Cell /// </summary> /// <param name="data"></param> /// <returns></returns> public static String FormatData(object data) { if (data.GetType() == typeof(String)) { return(WebUtil.FormatText(NullHandler.GetString(data))); } else if (data.GetType() == typeof(DateTime)) { return(NullHandler.GetDateTime(data).ToString(AppConstants.ValueOf.DATE_FROMAT_DISPLAY)); } else if (data.GetType() == typeof(decimal)) { return(String.Format(AppConstants.ValueOf.DECIMAL_FORMAT, NullHandler.GetDecimal(data))); } else if (data.GetType() == typeof(bool)) { return(NullHandler.GetBoolean(data) ? "Yes" : "No"); } else { return(NullHandler.GetString(data)); } }
public SavingState SaveItemsOrder(DataGridView dataGridViewOrder, string companyId, string srDsrId, string marketId, DateTime orderDate, SRDSRDue srDsrDue, bool isFromTemplate = false, bool isItemReturnedFromOrder = false, bool isDamagedItemReturnedFromOrder = false) { SavingState svState = SavingState.Failed; DbCommand thisCommand = null; try { thisCommand = GenericDataAccess.CreateCommand(); thisCommand.CommandType = CommandType.Text; GenericDataAccess.OpenDBConnection(thisCommand); if ((isFromTemplate && !IsSrDsrOrderExist(companyId, srDsrId, marketId, orderDate)) || (!isFromTemplate && IsSrDsrOrderExist(companyId, srDsrId, marketId, orderDate))) { foreach (DataGridViewRow row in dataGridViewOrder.Rows) { int stockAvailableInStore = 0; int damagedItemAvailableInStock = 0; if (string.IsNullOrEmpty(NullHandler.GetString(row.Cells["OrderId"].Value))) { /// insert the item order thisCommand.CommandText = "INSERT INTO IM_Orders (OrderId, CompanyId, SrId, MarketId, ItemId, Date, OrderCount, ReturnCount, SoldCount, DamagedCount) VALUES(@OrderId, @CompanyId, @SrId, @MarketId, @ItemId, @Date, @OrderCount, @ReturnCount, @SoldCount, @DamagedCount)"; CreateParameter.AddParam(thisCommand, "@OrderId", Guid.NewGuid().ToString(), DbType.String); CreateParameter.AddParam(thisCommand, "@CompanyId", companyId, DbType.String); CreateParameter.AddParam(thisCommand, "@SrId", srDsrId, DbType.String); CreateParameter.AddParam(thisCommand, "@MarketId", marketId, DbType.String); CreateParameter.AddParam(thisCommand, "@ItemId", NullHandler.GetString(row.Cells["ItemId"].Value), DbType.String); CreateParameter.AddParam(thisCommand, "@Date", orderDate.Date, DbType.Date); stockAvailableInStore = NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value) - NullHandler.GetInt32(row.Cells["SellsCount"].Value); damagedItemAvailableInStock = NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value); } else { /// update the item order based on OrderId thisCommand.CommandText = "UPDATE IM_Orders SET OrderCount = @OrderCount, ReturnCount = @ReturnCount, SoldCount = @SoldCount, DamagedCount = @DamagedCount WHERE OrderId = @OrderId"; CreateParameter.AddParam(thisCommand, "@OrderId", row.Cells["OrderId"].Value.ToString(), DbType.String); stockAvailableInStore = isItemReturnedFromOrder ? (NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value) + NullHandler.GetInt32(row.Cells["ReturnCount"].Value)) : NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value); damagedItemAvailableInStock = isDamagedItemReturnedFromOrder? (NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value) + NullHandler.GetInt32(row.Cells["DamageCount"].Value)): NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value); } CreateParameter.AddParam(thisCommand, "@OrderCount", row.Cells["OrderCount"].Value, DbType.Int32); CreateParameter.AddParam(thisCommand, "@ReturnCount", row.Cells["ReturnCount"].Value, DbType.Int32); CreateParameter.AddParam(thisCommand, "@DamagedCount", row.Cells["DamageCount"].Value, DbType.Int32); CreateParameter.AddParam(thisCommand, "@SoldCount", row.Cells["SellsCount"].Value, DbType.Int32); GenericDataAccess.ExecuteNonQueryTransaction(thisCommand); thisCommand.Parameters.Clear(); if (!string.IsNullOrEmpty(NullHandler.GetString(row.Cells["StockId"].Value))) { ItemStock stock = new ItemStock(); stock.StockId = NullHandler.GetString(row.Cells["StockId"].Value); stock.ItemId = NullHandler.GetString(row.Cells["ItemId"].Value); stock.ChalanNo = NullHandler.GetString(row.Cells["ChalanNo"].Value); stock.StockEntryDate = NullHandler.GetDateTime(row.Cells["StockEntryDate"].Value); stock.CurrentStockTotal = stockAvailableInStore;//NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value); stock.CurrentDamagedStockTotal = damagedItemAvailableInStock; svState = SaveStockItem(stock, thisCommand, true); } } } else { svState = SavingState.DuplicateExists; } } catch (Exception ex) { if (ex.Message.ToLower().Contains("duplicate key")) { svState = SavingState.DuplicateExists; } } finally { GenericDataAccess.CloseDBConnection(thisCommand); } if (svState.Equals(SavingState.Success) && !string.IsNullOrEmpty(srDsrDue.Id)) { svState = SRDSRManager.Instance.SaveSrDsrDue(srDsrDue); } return(svState); }