public static string Insert(string MaterialID, string MaterialName, string UnitID, string ActivityID)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
string id = "";
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 5);
param[0] = dbManager.getparam("@MaterialID", MaterialID);
param[1] = dbManager.getparam("@MaterialName", MaterialName);
param[2] = dbManager.getparam("@UnitID", Convert.ToInt16(UnitID));
param[3] = dbManager.getparam("@ActivityID", ActivityID);
param[4] = dbManager.getparam("@UserID", bllUtility.LoggedInSystemInformation.LoggedUserId);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "[USP_Material_InsertUpdate]", param);
id = Convert.ToString(dbManager.ExecuteScalar(cmd));
}
catch (Exception ex)
{
return("Err:" + ex.ToString());
}
finally
{
dbManager.Dispose();
}
return(id);
}
public static int Insert_account_sub_heads(string head_id, string sub_head)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
int chk;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 2);
param[0] = dbManager.getparam("@AccTypeID", head_id);
param[1] = dbManager.getparam("@AccountSubHead", sub_head);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "USP_SubAccountTransactionTypeInfo_insert", param);
chk = (int)dbManager.ExecuteScalar(cmd);
}
catch (Exception ex)
{
return(0);
}
finally
{
dbManager.Dispose();
}
return(chk);
}
public static string Insert_parent(CommissionCalc objTransaction, string created_by)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
string chk;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 3);
param[0] = dbManager.getparam("@AccountNo", objTransaction.AccountNo);
param[1] = dbManager.getparam("@CreatedBy", created_by);
param[2] = dbManager.getparam("@commission_date", objTransaction.CommissionCalcDate);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "USP_commission_parent_insert", param);
chk = Convert.ToString(dbManager.ExecuteScalar(cmd));
}
catch (Exception ex)
{
return("");
}
finally
{
dbManager.Dispose();
}
return(chk);
}
public static string Insert(string ZoneID, string ZoneName)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
string id = "";
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 2);
param[0] = dbManager.getparam("@ZoneID", Convert.ToInt16(ZoneID));
param[1] = dbManager.getparam("@ZoneName", ZoneName);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "USP_Zone_InsertUpdate", param);
id = Convert.ToString(dbManager.ExecuteScalar(cmd));
}
catch (Exception ex)
{
return("Err:" + ex.ToString());
}
finally
{
dbManager.Dispose();
}
return(id);
}