public JsonResult InsSalesStore(SalesStoreModel salesStore, SalesStoreAcctModel salesStoreAcct)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_SALES_STORE_TX_INS";
string[] spParamName = new string[] {
"@pi_strSalesStoreName", "@pi_strCEOName", "@pi_strLicenseNo", "@pi_strBankCode", "@pi_strAccountNo",
"@pi_strAccountHolder", "@pi_strAdminID", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
salesStore.SalesStoreName, salesStore.CEOName, salesStore.LicenseNo, salesStoreAcct.BankCode, salesStoreAcct.AccountNo,
salesStoreAcct.AccountHolder, strLoginID, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 890;
data.ErrMsg = "Exception in InsSalesStore : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult UpdSalesStore(SalesStoreModel salesStore, SalesStoreAcctModel salesStoreAcct)
{
Result data = null;
try
{
data = new Result();
string spName = "UP_SALES_STORE_TX_UPD";
string[] spParamName = new string[] {
"@pi_intSalesStoreNo", "@pi_strSalesStoreName", "@pi_strCEOName", "@pi_strLicenseNo", "@pi_intUseState",
"@pi_strBankCode", "@pi_strAccountNo", "@pi_strAccountHolder", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
salesStore.SalesStoreNo, salesStore.SalesStoreName, salesStore.CEOName, salesStore.LicenseNo, salesStore.UseState,
salesStoreAcct.BankCode, salesStoreAcct.AccountNo, salesStoreAcct.AccountHolder, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 880;
data.ErrMsg = "Exception in UpdSalesStore : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult DetailSalesStore(SalesStoreModel salesStore)
{
Result <SalesStoreModel> data = null;
try
{
data = new Result <SalesStoreModel>();
string spName = "UP_SALES_STORE_AR_LST";
string[] spParamName = new string[] {
"@pi_intSalesStoreNo", "@pi_strSalesStoreName", "@pi_strCEOName", "@pi_intUseState"
};
object[] spParamValue = new object[] {
salesStore.SalesStoreNo, DBNull.Value, DBNull.Value, DBNull.Value
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
data.data = new SalesStoreModel
{
SalesStoreNo = Convert.ToInt64(row["SALESSTORENO"]),
SalesStoreName = row["SALESSTORENAME"].ToString(),
CEOName = row["CEONAME"].ToString(),
LicenseNo = row["LICENSENO"].ToString(),
UseState = Convert.ToInt16(row["USESTATE"]),
AdminID = row["ADMINID"].ToString(),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString() ?? "",
objSalesStoreAcctModel = new SalesStoreAcctModel
{
BankCode = row["BANKCODE"].ToString(),
AccountNo = row["ACCOUNTNO"].ToString(),
AccountHolder = row["ACCOUNTHOLDER"].ToString()
}
};
}
}
}
catch (Exception ex)
{
data.RetVal = 899;
data.ErrMsg = "Exception in DetailSalesStore : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult GetSalesStoreList(SalesStoreModel salesStore)
{
List <SalesStoreModel> data = new List <SalesStoreModel>();
try
{
string spName = "UP_SALES_STORE_AR_LST";
string[] spParamName = new string[] {
"@pi_intSalesStoreNo", "@pi_strSalesStoreName", "@pi_strCEOName", "@pi_intUseState"
};
object[] spParamValue = new object[] {
salesStore.SalesStoreNo, DBNull.Value, salesStore.CEOName ?? "", salesStore.UseState
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
SalesStoreModel obj = new SalesStoreModel
{
SalesStoreNo = Convert.ToInt64(row["SALESSTORENO"]),
SalesStoreName = row["SALESSTORENAME"].ToString(),
CEOName = row["CEONAME"].ToString(),
LicenseNo = row["LICENSENO"].ToString(),
UseState = Convert.ToInt16(row["USESTATE"]),
AdminID = row["ADMINID"].ToString(),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString() ?? ""
};
data.Add(obj);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetSalesStoreList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
