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);
}
private Party CreateObject(NullHandler oReader)
{
Party oParty = new Party();
MapObject(oParty, oReader);
return(oParty);
}
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 DueCollection CreateObject(NullHandler oReader)
{
DueCollection oDueCollection = new DueCollection();
MapObject(oDueCollection, oReader);
return(oDueCollection);
}
private AddBranch CreateObject(NullHandler oReader)
{
AddBranch oAddBranch = new AddBranch();
MapObject(oAddBranch, oReader);
return(oAddBranch);
}
private PurchaseOrderDetail CreateObject(NullHandler oReader)
{
PurchaseOrderDetail oPurchaseOrderDetail = new PurchaseOrderDetail();
MapObject(oPurchaseOrderDetail, oReader);
return(oPurchaseOrderDetail);
}
private ChartOfAcc CreateObject(NullHandler oReader)
{
ChartOfAcc oChartOfAcc = new ChartOfAcc();
MapObject(oChartOfAcc, oReader);
return(oChartOfAcc);
}
private Transaction CreateObject(NullHandler oReader)
{
Transaction oTransaction = new Transaction();
MapObject(oTransaction, oReader);
return(oTransaction);
}
private UserFunctionality CreateObject(NullHandler oReader)
{
UserFunctionality oUserFunctionality = new UserFunctionality();
MapObject(oUserFunctionality, oReader);
return(oUserFunctionality);
}
private ProductLot CreateObject(NullHandler oReader)
{
ProductLot oProductLot = new ProductLot();
MapObject(oProductLot, oReader);
return(oProductLot);
}
public bool PWReset(int nUserID)
{
bool _bReturTF = false;
try
{
NewUser oNewUser = new NewUser();
IDataReader reader = ExecuteQueryFunctions.ExeReader(_conn, "SELECT * FROM User_Table AS ut WHERE [user_id]=" + nUserID);
NullHandler oReader = new NullHandler(reader);
if (reader.Read())
{
oNewUser = CreateObject(oReader);
}
reader.Close();
_conn.Close();
string QueryString = "UPDATE User_Table SET user_name='" + oNewUser.user_name_ini + "',user_pass='******',UpdateBy=" + EMSGlobal._nCurrentUserID + " WHERE user_id=" + nUserID;
ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString);
_bReturTF = true;
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(_bReturTF);
}
private LoginInterface CreateObject(NullHandler oReader)
{
LoginInterface oLoginInterface = new LoginInterface();
MapObject(oLoginInterface, oReader);
return(oLoginInterface);
}
private SaleOrderDetail CreateObject(NullHandler oReader)
{
SaleOrderDetail oSaleOrderDetail = new SaleOrderDetail();
MapObject(oSaleOrderDetail, oReader);
return(oSaleOrderDetail);
}
private BankAccount CreateObject(NullHandler oReader)
{
BankAccount oBankAccount = new BankAccount();
MapObject(oBankAccount, oReader);
return(oBankAccount);
}
public decimal GetTotalPaymentsOf(string srDsrId, string companyId, DateTime paymentDate)
{
DbCommand comm = null;
decimal totalPayment = 0;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = @"SELECT TotalPayment FROM IM_SR_DSR_PAYMENT_DETAILS WHERE SrId = @SrId AND CompanyId = @CompanyId AND PaymentDate = @PaymentDate";
CreateParameter.AddParam(comm, "@SrId", srDsrId, DbType.String);
CreateParameter.AddParam(comm, "@CompanyId", companyId, DbType.String);
CreateParameter.AddParam(comm, "@PaymentDate", paymentDate.Date, DbType.DateTime);
DbDataReader dr = GenericDataAccess.ExecuteQuery(comm);
if (dr.Read())
{
totalPayment = NullHandler.GetDecimal(dr["TotalPayment"]);
}
}
catch (Exception ex)
{
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(totalPayment);
}
public ProductConfigure GetByID(int nID)
{
ProductConfigure oProductConfigure = new ProductConfigure();
try
{
SqlCommand cmd = new SqlCommand("SP_ProductConfigure_GetByID", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PCID", SqlDbType.Int)).Value = nID;
if (_conn.State == ConnectionState.Open)
{
}
else
{
cmd.Connection.Open();
}
IDataReader reader = cmd.ExecuteReader();
NullHandler oReader = new NullHandler(reader);
if (reader.Read())
{
oProductConfigure = CreateObject(oReader);
}
cmd.Dispose();
cmd.Connection.Close();
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oProductConfigure);
}
private ProductConfigure CreateObject(NullHandler oReader)
{
ProductConfigure oProductConfigure = new ProductConfigure();
MapObject(oProductConfigure, oReader);
return(oProductConfigure);
}
private ManuInterface CreateObject(NullHandler oReader)
{
ManuInterface oManuInterface = new ManuInterface();
MapObject(oManuInterface, oReader);
return(oManuInterface);
}
public void StorageVirtuosoLoadGraphWithNullHandler()
{
NTriplesFormatter formatter = new NTriplesFormatter();
VirtuosoManager manager = VirtuosoTest.GetConnection();
try
{
Assert.IsNotNull(manager);
Console.WriteLine("Got the Virtuoso Manager OK");
//Add the Test Date to Virtuoso
Graph testData = new Graph();
FileLoader.Load(testData, "resources\\Turtle.ttl");
testData.BaseUri = new Uri("http://example.org/virtuoso/tests/null");
manager.SaveGraph(testData);
Console.WriteLine("Saved the Test Data to Virtuoso");
NullHandler handler = new NullHandler();
manager.LoadGraph(handler, testData.BaseUri);
}
finally
{
if (manager != null)
{
manager.Dispose();
}
}
}
private ProdCatagory CreateObject(NullHandler oReader)
{
ProdCatagory oProdCatagory = new ProdCatagory();
MapObject(oProdCatagory, oReader);
return(oProdCatagory);
}
private UserFunction CreateObject(NullHandler oReader)
{
UserFunction oUserFunction = new UserFunction();
MapObject(oUserFunction, oReader);
return(oUserFunction);
}
private Challan CreateObject(NullHandler oReader)
{
Challan oChallan = new Challan();
MapObject(oChallan, oReader);
return(oChallan);
}
private NewUser CreateObject(NullHandler oReader)
{
NewUser oNewUser = new NewUser();
MapObject(oNewUser, oReader);
return(oNewUser);
}
private MenuPermission CreateObject(NullHandler oReader)
{
MenuPermission oMenuPermission = new MenuPermission();
MapObject(oMenuPermission, oReader);
return(oMenuPermission);
}
/// <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(ProdCatagory oProdCatagory, NullHandler oReader)
{
BusinessObject.Factory.SetID(oProdCatagory, new ID(oReader.GetInt32("catId")));
oProdCatagory.catName = oReader.GetString("catName");
BusinessObject.Factory.SetObjectState(oProdCatagory, ObjectState.Saved);
}
private SRDSRDue MapSrDsrDue(DbDataReader dr)
{
SRDSRDue srDsrDue = new SRDSRDue();
srDsrDue.Id = NullHandler.GetString(dr["SrId"]);
srDsrDue.Due = NullHandler.GetDouble(dr["TotalDue"]);
return(srDsrDue);
}
/// <summary>
/// Formats the given object.
/// </summary>
/// <param name="value">The object to format.</param>
/// <returns>The formatted value.</returns>
public override string Format(object value)
{
if (value == null)
{
return(NullHandler.GetNullRepresentation());
}
char[] actual = (char[])value;
return(new String(actual));
}
private Company MapCompany(DbDataReader dr)
{
Company company = new Company();
company.companyId = NullHandler.GetString(dr["CompanyId"]);
company.companyName = NullHandler.GetString(dr["CompanyName"]);
return(company);
}
/// <summary>
/// Parses the given value as a char array.
/// </summary>
/// <param name="value">The value to parse.</param>
/// <returns>The parsed char array.</returns>
public override object Parse(string value)
{
if (NullHandler.IsNullRepresentation(value))
{
return(null);
}
value = TrimValue(value);
return(value.ToCharArray());
}
