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