public CResult Create(CPriceMaster oPM)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Price_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
//
cmd.Parameters.AddWithValue("@Price_OId", oPM.Price_OId);
cmd.Parameters.AddWithValue("@Price_Branch", oPM.Price_Branch);
cmd.Parameters.AddWithValue("@Price_ItemOId", oPM.Price_ItemOId);
cmd.Parameters.AddWithValue("@Price_FromDate", oPM.Price_FromDate);
cmd.Parameters.AddWithValue("@Price_ToDate", oPM.Price_ToDate);
cmd.Parameters.AddWithValue("@Price_Currency", oPM.Price_Currency);
cmd.Parameters.AddWithValue("@Price_FactoryPrice", oPM.Price_FactoryPrice);
cmd.Parameters.AddWithValue("@Price_ListPrice", oPM.Price_ListPrice);
cmd.Parameters.AddWithValue("@Price_VatPercent", oPM.Price_VatPercent);
cmd.Parameters.AddWithValue("@Price_VatPrice", oPM.Price_VatPrice);
cmd.Parameters.AddWithValue("@Price_Disc", oPM.Price_Disc);
cmd.Parameters.AddWithValue("@Price_DiscPrice", oPM.Price_DiscPrice);
cmd.Parameters.AddWithValue("@Price_Creator", oPM.Creator);
cmd.Parameters.AddWithValue("@Price_CreationDate", oPM.CreationDate);
cmd.Parameters.AddWithValue("@Price_UpdateBy", oPM.UpdateBy);
cmd.Parameters.AddWithValue("@Price_UpdateDate", oPM.UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CParty oParty)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Party_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Party_Branch", oParty.Party_Branch);
cmd.Parameters.AddWithValue("@Party_Name", oParty.Party_Name);
cmd.Parameters.AddWithValue("@Party_Address", oParty.Party_Address);
cmd.Parameters.AddWithValue("@Party_City", oParty.Party_City);
cmd.Parameters.AddWithValue("@Party_Country", oParty.Party_Country);
cmd.Parameters.AddWithValue("@Party_Phone", oParty.Party_Phone);
cmd.Parameters.AddWithValue("@Party_Mobile", oParty.Party_Mobile);
cmd.Parameters.AddWithValue("@Party_Email", oParty.Party_Email);
cmd.Parameters.AddWithValue("@Party_ContactPerson1", oParty.Party_ContactPerson1);
cmd.Parameters.AddWithValue("@Party_Phone1", oParty.Party_Phone1);
cmd.Parameters.AddWithValue("@Party_Contactperson2", oParty.Party_Contactperson2);
cmd.Parameters.AddWithValue("@Party_Phone2", oParty.Party_Phone2);
cmd.Parameters.AddWithValue("@Party_Creator", oParty.Creator);
cmd.Parameters.AddWithValue("@Party_CreationDate", oParty.CreationDate);
cmd.Parameters.AddWithValue("@Party_UpdateBy", oParty.UpdateBy);
cmd.Parameters.AddWithValue("@Party_UpdateDate", oParty.UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
//public CResult Update(CInventory oInventory)
//{
// oResult = new CResult();
// conn = oConnManager.GetConnection(out s_DBError);
// if (conn != null)
// {
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.Parameters.Clear();
// cmd.Transaction = oConnManager.BeginTransaction();
// try
// {
// cmd.CommandText = "sp_Inventory_Update";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Invt_OID", oInventory.Invt_OID);
// cmd.Parameters.AddWithValue("@Invt_Branch", oInventory.Invt_Branch);
// cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
// cmd.Parameters.AddWithValue("@Invt_QTY", oInventory.Invt_QTY);
// cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
// cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
// cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
// cmd.ExecuteNonQuery();
// oConnManager.Commit();
// oResult.IsSuccess = true;
// }
// catch (SqlException e)
// {
// oResult.ErrMsg = e.Message;
// oResult.IsSuccess = false;
// string sRollbackError = oConnManager.Rollback();
// }
// finally
// {
// oConnManager.Close();
// }
// }
// else
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = s_DBError;
// }
// return oResult;
//}
public CResult ReadQtyByCond(CInventory oInventory)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_Invt_ReadQtyByCond";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
SqlDataReader oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
oInventory.Invt_QTY = float.Parse(oReader["Invt_QTY"].ToString());
}
oReader.Close();
}
oResult.IsSuccess = true;
oResult.Data = oInventory;
}
catch (SqlException e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CUOM oUOM)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_UOM_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UOM_Code", oUOM.UOM_Code);
cmd.Parameters.AddWithValue("@UOM_Name", oUOM.UOM_Name);
cmd.Parameters.AddWithValue("@UOM_Branch", oUOM.UOM_Branch);
cmd.Parameters.AddWithValue("@Creator", oUOM.Creator);
cmd.Parameters.AddWithValue("@CreationDate", oUOM.CreationDate);
cmd.Parameters.AddWithValue("@UpdateBy", oUOM.UpdateBy);
cmd.Parameters.AddWithValue("@UpdateDate", oUOM.UpdateDate);
cmd.Parameters.AddWithValue("@IsActive", oUOM.IsActive);
cmd.Parameters.AddWithValue("@Remarks", oUOM.Remarks);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CCurrency oCurrency)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("DECLARE @NextId NCHAR(24);");
sBuilder.Append("EXEC sp_GetNextId 'Curr_OID','Curr', @Curr_Branch, @NextId OUTPUT;");
sBuilder.Append(" Insert into t_Curr values(@NextId,@Curr_Branch,@Curr_Code,@Curr_Name)");
cmd.CommandText = sBuilder.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Curr_Branch", oCurrency.Curr_Branch);
cmd.Parameters.AddWithValue("@Curr_Code", oCurrency.Curr_Code);
cmd.Parameters.AddWithValue("@Curr_Name", oCurrency.Curr_Name);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CReorderLevel oReorderLevel)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_ReorderLevelInsert";
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Cust_OID", oReorderLevel.OID);
cmd.Parameters.AddWithValue("@Cust_Branch", oReorderLevel.Branch_ID);
cmd.Parameters.AddWithValue("@ItemID", oReorderLevel.Item_ID);
cmd.Parameters.AddWithValue("@LocationID", oReorderLevel.Location_ID);
cmd.Parameters.AddWithValue("@Quantity", oReorderLevel.Quantity);
cmd.Parameters.AddWithValue("@Remarks", oReorderLevel.Remarks);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult ReadAll()
{
List <CCompany> oList = new List <CCompany>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_Company_ReadAll";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dtItem = ds.Tables[0];
foreach (DataRow dr in dtItem.Rows)
{
oList.Add(GetResultSetToCompany(dr));
}
oResult.IsSuccess = true;
oResult.Data = oList;
}
catch (Exception e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult ReadLastCodeNo(string stColumnName, string stTableName, string stBranchCode)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_GetNextCodeNo";
cmd.CommandType = CommandType.StoredProcedure;
//@ColumnName,@TableName,@NextId,@BranchCode
cmd.Parameters.AddWithValue("@ColumnName", stColumnName);
cmd.Parameters.AddWithValue("@TableName", stTableName);
cmd.Parameters.Add("@NextId", SqlDbType.Char, 16);
cmd.Parameters.AddWithValue("@BranchCode", stBranchCode);
cmd.Parameters["@NextId"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
oResult.Data = cmd.Parameters["@NextId"].Value.ToString();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CUser oUser)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_UserInsert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Branch", oUser.User_Branch);
cmd.Parameters.AddWithValue("@UserID", oUser.User_UserID);
cmd.Parameters.AddWithValue("@UserName", oUser.User_UserName);
cmd.Parameters.AddWithValue("@Passward", oUser.User_Passward);
cmd.Parameters.AddWithValue("@UserType", oUser.User_UserType);
cmd.Parameters.AddWithValue("@UserStatus", oUser.User_UserStatus);
// cmd.Parameters.AddWithValue("@CreatedDate", oUser.User_CreatedDate);
// cmd.Parameters.AddWithValue("@Phone", oUser.Phone);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = null;
CConManager oConnManager = new CConManager();
string s_DBError = "";
string Item_OID = "";
string ItemCode = txtStartCode.Text;
int st = Convert.ToInt32(txtStart.Text);
int en = Convert.ToInt32(txtend.Text);
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
for (; st <= en; st++)
{
string strItemCode = ItemCode.Substring(0, 4);
string strCode = "" + Convert.ToString(Convert.ToInt32(ItemCode.Substring(4)) + 1);
for (int j = 5; j > (strCode.Length); j--)
{
strItemCode += "0";
}
ItemCode = strItemCode + strCode;
for (int j = 10; j > (st.ToString().Length); j--)
{
Item_OID += "0";
}
Item_OID += st.ToString();
string sql = "UPDATE t_Item SET Item_Code = '" + ItemCode + "' WHERE Item_OID='ItemXXXXBRN01 " + Item_OID + "'";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (SqlException ewe)
{
}
Item_OID = "";
}
}
oConnManager.Close();
txtStartCode.Text = ItemCode;
}
public CResult Create(CCVB oCVB)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_CVB_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CVB_Company", oCVB.Company);
cmd.Parameters.AddWithValue("@CVB_Branch", oCVB.Branch);
cmd.Parameters.Add("@IsSuccess", SqlDbType.Char, 1);
cmd.Parameters["@IsSuccess"].Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
string st = cmd.Parameters["@IsSuccess"].Value.ToString();
oConnManager.Commit();
oResult.Data = st;
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CPayment oPayment)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Payment_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Payment_Branch", oPayment.Payment_Branch);
cmd.Parameters.AddWithValue("@Payment_Date", oPayment.Payment_Date);
cmd.Parameters.AddWithValue("@Payment_PartyOID", oPayment.Payment_PartyOID);
cmd.Parameters.AddWithValue("@Payment_Amount", oPayment.Payment_Amount);
cmd.Parameters.AddWithValue("@Payment_CurrencyOID", oPayment.Payment_CurrencyOID);
cmd.Parameters.AddWithValue("@Payment_CurrencyRate", oPayment.Payment_CurrencyRate);
cmd.Parameters.AddWithValue("@Payment_BDT", oPayment.Payment_BDT);
cmd.Parameters.AddWithValue("@Payment_Media", oPayment.Payment_Media);
cmd.Parameters.AddWithValue("@Payment_RecieptConfirmation", oPayment.Payment_RecieptConfirmation);
cmd.Parameters.AddWithValue("@Payment_ReceivedDate", oPayment.Payment_ReceivedDate);
cmd.Parameters.AddWithValue("@Payment_Creator", oPayment.Creator);
cmd.Parameters.AddWithValue("@Payment_CreationDate", oPayment.CreationDate);
cmd.Parameters.AddWithValue("@Payment_UpdateBy", oPayment.UpdateBy);
cmd.Parameters.AddWithValue("@Payment_UpdateDate", oPayment.UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CPurchase oPurchase)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Purchase_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Purchase_Branch", oPurchase.Purchase_Branch);
cmd.Parameters.AddWithValue("@Purchase_PartyOID", oPurchase.Purchase_PartyOID);
cmd.Parameters.AddWithValue("@Purchase_GroupID", oPurchase.Purchase_GroupID);
cmd.Parameters.AddWithValue("@Purchase_Description", oPurchase.Purchase_Description);
cmd.Parameters.AddWithValue("@Purchase_Quantity", oPurchase.Purchase_Quantity);
cmd.Parameters.AddWithValue("@Purchase_Amount", oPurchase.Purchase_Amount);
cmd.Parameters.AddWithValue("@Purchase_CurrencyOID", oPurchase.Purchase_CurrencyOID);
cmd.Parameters.AddWithValue("@Purchase_CurrencyRate", oPurchase.Purchase_CurrencyRate);
cmd.Parameters.AddWithValue("@Purchase_Invoice", oPurchase.Purchase_Invoice);
cmd.Parameters.AddWithValue("@Purchase_Date", oPurchase.Purchase_Date);
cmd.Parameters.AddWithValue("@Purchase_Status", oPurchase.Purchase_Status);
cmd.Parameters.AddWithValue("@Purchase_Creator", oPurchase.Purchase_Creator);
cmd.Parameters.AddWithValue("@Purchase_CreationDate", oPurchase.Purchase_CreationDate);
cmd.Parameters.AddWithValue("@Purchase_UpdateBy", oPurchase.Purchase_UpdateBy);
cmd.Parameters.AddWithValue("@Purchase_UpdateDate", oPurchase.Purchase_UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public DataTable ReadAll(DateTime dat, string branchcode)
{
DataTable dt = new DataTable();
ArrayList oUOMList = new ArrayList();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_CardCashSale";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SOMstr_Date", dat);
cmd.Parameters.AddWithValue("@CompBrn_OID", branchcode);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
dt = ds.Tables[0];
}
catch (SqlException e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(dt);
}
public CResult Create(CMemberShip oMemberShip)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("DECLARE @NextId NCHAR(24);");
sBuilder.Append("EXEC sp_GetNextId 'Member_OID','Member', @Member_Branch, @NextId OUTPUT;");
sBuilder.Append(" Insert into t_Member values(@NextId,@Member_Branch,");
sBuilder.Append("@Member_MembershipID,@Member_Name,@Member_Mobile,@Member_DateOfBirth,");
sBuilder.Append("@Member_FromDate,@Member_ToDate,@Member_Address,");
sBuilder.Append("@Member_Area,@Member_PostCode,@Member_Phone,@Member_Email,@Member_Occupation,@Member_FamilyMember,");
sBuilder.Append("@Member_CreatedBy,@Member_CreationDate,@Member_UpdateBy,@Member_UpdateDate,@Member_IsActive,@Member_DiscountAmount)");
cmd.CommandText = sBuilder.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Member_Branch", oMemberShip.Branch);
cmd.Parameters.AddWithValue("@Member_MembershipID", oMemberShip.MembershipID);
cmd.Parameters.AddWithValue("@Member_Name", oMemberShip.MemberName);
cmd.Parameters.AddWithValue("@Member_Mobile", oMemberShip.Mobile);
cmd.Parameters.AddWithValue("@Member_DateOfBirth", oMemberShip.DateOfBirth);
cmd.Parameters.AddWithValue("@Member_FromDate", oMemberShip.Fromdate);
cmd.Parameters.AddWithValue("@Member_ToDate", oMemberShip.Todate);
cmd.Parameters.AddWithValue("@Member_Address", oMemberShip.Address);
cmd.Parameters.AddWithValue("@Member_Area", oMemberShip.Area);
cmd.Parameters.AddWithValue("@Member_PostCode", oMemberShip.PostCode);
cmd.Parameters.AddWithValue("@Member_Phone", oMemberShip.Phone);
cmd.Parameters.AddWithValue("@Member_Email", oMemberShip.Email);
cmd.Parameters.AddWithValue("@Member_Occupation", oMemberShip.Occupation);
cmd.Parameters.AddWithValue("@Member_FamilyMember", oMemberShip.FamilyMember);
cmd.Parameters.AddWithValue("@Member_CreatedBy", oMemberShip.Creator);
cmd.Parameters.AddWithValue("@Member_CreationDate", oMemberShip.CreationDate);
cmd.Parameters.AddWithValue("@Member_UpdateBy", "");
cmd.Parameters.AddWithValue("@Member_UpdateDate", "");
cmd.Parameters.AddWithValue("@Member_IsActive", 1);
cmd.Parameters.AddWithValue("@Member_DiscountAmount", oMemberShip.Member_DiscountAmount);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CMTMaster oMTMaster)
{
List <CInventory> oSrcInvtList = new List <CInventory>();
List <CInventory> oDesInvtList = new List <CInventory>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_MTMstr_Insert";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@MTMstr_OID", oMTMaster.MTMstr_OID);
SqlParameter sParam = new SqlParameter("@MTMstr_OID", SqlDbType.Char, 24);
sParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(sParam).Value = "";
cmd.Parameters.AddWithValue("@MTMstr_Branch", oMTMaster.MTMstr_Branch);
cmd.Parameters.AddWithValue("@MTMstr_Code", oMTMaster.MTMstr_Code);
cmd.Parameters.AddWithValue("@MTMstr_Date", oMTMaster.MTMstr_Date);
cmd.Parameters.AddWithValue("@MTMstr_DOrder", oMTMaster.MTMstr_DOrder);
cmd.Parameters.AddWithValue("@MTMstr_Creator", oMTMaster.Creator);
cmd.Parameters.AddWithValue("@MTMstr_CreationDate", oMTMaster.CreationDate);
cmd.Parameters.AddWithValue("@MTMstr_UpdatedBy", oMTMaster.UpdateBy);
cmd.Parameters.AddWithValue("@MTMstr_UpdateDate", oMTMaster.UpdateDate);
cmd.Parameters.AddWithValue("@MTMstr_IsActive", (oMTMaster.IsActive == "Y")?1:0);
cmd.Parameters.AddWithValue("@MTMstr_Remarks", oMTMaster.Remarks);
cmd.ExecuteNonQuery();
string stMTMstr_OID = cmd.Parameters["@MTMstr_OID"].Value.ToString();
foreach (CMTDetails oDetails in oMTMaster.MTMstr_DetailsList)
{
cmd.CommandText = "sp_MTDtls_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@MTDtls_Branch", oDetails.MTDtls_Branch);
cmd.Parameters.AddWithValue("@MTDtls_OID", oDetails.MTDtls_OID);
cmd.Parameters.AddWithValue("@MTDtls_MstrOID", stMTMstr_OID);
cmd.Parameters.AddWithValue("@MTDtls_ItemOID", oDetails.MTDtls_ItemOID);
cmd.Parameters.AddWithValue("@MTDtls_IssQty", oDetails.MTDtls_IssQty);
cmd.Parameters.AddWithValue("@MTDtls_IssUOMOID", oDetails.MTDtls_IssUOMOID);
cmd.Parameters.AddWithValue("@MTDtls_SBranOID", oDetails.MTDtls_SBranOID);
cmd.Parameters.AddWithValue("@MTDtls_SrcLocOID", oDetails.MTDtls_SrcLocOID);
cmd.Parameters.AddWithValue("@MTDtls_SrcInvTyp", oDetails.MTDtls_SrcInvTyp);
cmd.Parameters.AddWithValue("@MTDtls_DBranOID", oDetails.MTDtls_DBranOID);
cmd.Parameters.AddWithValue("@MTDtls_DestLocOID", oDetails.MTDtls_DestLocOID);
cmd.Parameters.AddWithValue("@MTDtls_DesInvtyp", oDetails.MTDtls_DesInvtyp);
cmd.Parameters.AddWithValue("@MTDtls_RQty", oDetails.MTDtls_RQty);
cmd.Parameters.AddWithValue("@MTDtls_RUOMOID", oDetails.MTDtls_RUOMOID);
cmd.Parameters.AddWithValue("@MTDtls_Status", oDetails.MTDtls_Status);
cmd.ExecuteNonQuery();
// populate inv list(decrease)
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.MTDtls_Branch;
oInventory.Invt_BranchOID = oDetails.MTDtls_SBranOID;
oInventory.Invt_InvType = oDetails.MTDtls_SrcInvTyp;
oInventory.Invt_ItemOID = oDetails.MTDtls_ItemOID;
oInventory.Invt_LocOID = oDetails.MTDtls_SrcLocOID;
oInventory.Invt_QTY = oDetails.MTDtls_IssQty;
oSrcInvtList.Add(oInventory);
// populate inv list(increase)
oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.MTDtls_Branch;
oInventory.Invt_BranchOID = oDetails.MTDtls_DBranOID;
oInventory.Invt_InvType = oDetails.MTDtls_DesInvtyp;
oInventory.Invt_ItemOID = oDetails.MTDtls_ItemOID;
oInventory.Invt_LocOID = oDetails.MTDtls_DestLocOID;
oInventory.Invt_QTY = oDetails.MTDtls_IssQty;
oDesInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtDecInc(oSrcInvtList, oDesInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CEmployee oEmployee)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_EmployeeInsert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmpID", oEmployee.EmpID);
cmd.Parameters.AddWithValue("@Name", oEmployee.Name);
cmd.Parameters.AddWithValue("@FName", oEmployee.FName);
cmd.Parameters.AddWithValue("@MName", oEmployee.MName);
cmd.Parameters.AddWithValue("@SName", oEmployee.SName);
cmd.Parameters.AddWithValue("@PerAddress", oEmployee.PerAddress);
cmd.Parameters.AddWithValue("@PerDistrict", oEmployee.PerDistrict);
cmd.Parameters.AddWithValue("@PreAddress", oEmployee.PreAddress);
cmd.Parameters.AddWithValue("@PreDistrict", oEmployee.PreDistrict);
cmd.Parameters.AddWithValue("@DOB", oEmployee.DOB);
cmd.Parameters.AddWithValue("@BloodGroup", oEmployee.BloodGroup);
cmd.Parameters.AddWithValue("@DOJ", oEmployee.DOJ);
cmd.Parameters.AddWithValue("@PcardNo", oEmployee.PcardNo);
cmd.Parameters.AddWithValue("@Sex", oEmployee.Sex);
cmd.Parameters.AddWithValue("@UnitID", oEmployee.UnitID);
cmd.Parameters.AddWithValue("@EmployeeType", oEmployee.EmployeeType);
cmd.Parameters.AddWithValue("@FloorID", oEmployee.FloorID);
cmd.Parameters.AddWithValue("@SectionID", oEmployee.SectionID);
cmd.Parameters.AddWithValue("@BlockID", oEmployee.BlockID);
cmd.Parameters.AddWithValue("@DesignationID", oEmployee.DesignationID);
cmd.Parameters.AddWithValue("@GradeID", oEmployee.GradeID);
cmd.Parameters.AddWithValue("@Basic", oEmployee.Basic);
cmd.Parameters.AddWithValue("@HouseRent", oEmployee.HouseRent);
cmd.Parameters.AddWithValue("@Medical", oEmployee.Medical);
cmd.Parameters.AddWithValue("@Conveyance", oEmployee.Conveyance);
cmd.Parameters.AddWithValue("@Shift", oEmployee.Shift);
cmd.Parameters.AddWithValue("@IsAllowance", oEmployee.IsAllowance);
cmd.Parameters.AddWithValue("@IsAttendanceBonus", oEmployee.IsAttendanceBonus);
cmd.Parameters.AddWithValue("@IsOT", oEmployee.IsOT);
cmd.Parameters.AddWithValue("@IsActive", oEmployee.IsActive);
cmd.Parameters.AddWithValue("@Education", oEmployee.Education);
cmd.Parameters.AddWithValue("@Remarks", oEmployee.Remarks);
//cmd.Parameters.AddWithValue("@GName", oGroup.GName);
//cmd.Parameters.AddWithValue("@SID", oGroup.SID);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CGRMaster oMaster)
{
List <CInventory> oInvtList = new List <CInventory>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
//
cmd.CommandText = "sp_GRMaster_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GRMstr_OID", SqlDbType.Char, 24);
cmd.Parameters["@GRMstr_OID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch);
cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code);
cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date);
cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type);
cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By);
cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy);
cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID);
cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt);
cmd.Parameters.AddWithValue("@Creator", oMaster.Creator);
cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate);
cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy);
cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate);
cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0);
cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks);
cmd.Parameters.AddWithValue("@IsImported", oMaster.GRMstr_IsImported);
cmd.ExecuteNonQuery();
string stGRMStr_OID = cmd.Parameters["@GRMstr_OID"].Value.ToString();
if (stGRMStr_OID.Trim() == "")
{
oResult.ErrMsg = "This delivered data is already exists.";
oResult.IsSuccess = false;
return(oResult);
}
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
cmd.CommandText = "sp_GRDetails_Insert";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch);
cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID);
cmd.Parameters.AddWithValue("@GRDet_MStrOID", stGRMStr_OID);
cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID);
cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY);
cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM);
cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID);
cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID);
cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType);
cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price);
cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency);
cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount);
cmd.ExecuteNonQuery();
// populate inv list
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.GRDet_Branch;
oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID;
oInventory.Invt_InvType = oDetails.GRDet_InvType;
oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID;
oInventory.Invt_LocOID = oDetails.GRDet_LocOID;
oInventory.Invt_QTY = oDetails.GRDet_QTY;
oInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtInc(oInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CSupplier oCS)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Cust_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
//
cmd.Parameters.AddWithValue("@Cust_OId", oCS.Cust_OId);
cmd.Parameters.AddWithValue("@Cust_Branch", oCS.Cust_Branch);
cmd.Parameters.AddWithValue("@Cust_Id", oCS.Cust_Id);
cmd.Parameters.AddWithValue("@Cust_Name", oCS.Cust_Name);
cmd.Parameters.AddWithValue("@Cust_CSType", oCS.Cust_CSType);
cmd.Parameters.AddWithValue("@Cust_ContactP", oCS.Cust_ContactP);
cmd.Parameters.AddWithValue("@Cust_Address", oCS.Cust_Address);
cmd.Parameters.AddWithValue("@Cust_Cell", oCS.Cust_Cell);
cmd.Parameters.AddWithValue("@Cust_Phone", oCS.Cust_Phone);
cmd.Parameters.AddWithValue("@Cust_Email", oCS.Cust_Email);
cmd.Parameters.AddWithValue("@Cust_Fax", oCS.Cust_Fax);
cmd.Parameters.AddWithValue("@Cust_Web", oCS.Cust_Web);
cmd.Parameters.AddWithValue("@Cust_IsActive", oCS.Cust_IsActive);
cmd.Parameters.AddWithValue("@Cust_DiscRate", oCS.Cust_DiscRate);
cmd.Parameters.AddWithValue("@Cust_Creator", oCS.Creator);
cmd.Parameters.AddWithValue("@Cust_CreationDate", oCS.CreationDate);
cmd.Parameters.AddWithValue("@Cust_UpdateBy", oCS.UpdateBy);
cmd.Parameters.AddWithValue("@Cust_UpdateDate", oCS.UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
