//for update mapping
internal int GetAc_UpdateConfiguration(int Id, string OCode, string Company_Code, string ItemCode, string ItemName, string LedgerCode, string LedgerName, string ModuleId, string ModuleName, string TransactionNature, string ModuleType)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var Id_ = new SqlParameter("@Id", Id);
var OCode_ = new SqlParameter("@OCode", OCode);
var Company_Code_ = new SqlParameter("@Company_Code", Company_Code);
var ItemCode_ = new SqlParameter("@ItemCode", ItemCode);
var ItemName_ = new SqlParameter("@ItemName", ItemName);
var LedgerCode_ = new SqlParameter("@LedgerCode", LedgerCode);
var LedgerName_ = new SqlParameter("@LedgerName", LedgerName);
var ModuleId_ = new SqlParameter("@ModuleId", ModuleId);
var ModuleName_ = new SqlParameter("@ModuleName", ModuleName);
var TransactionNature_ = new SqlParameter("@TransactionNature", TransactionNature);
var ModuleType_ = new SqlParameter("@ModuleType", ModuleType);
string SP_SQL = "Conf_Get_UpdateConfiguration @Id,@OCode,@Company_Code,@ItemCode,@ItemName,@LedgerCode,@LedgerName,@ModuleId,@ModuleName,@TransactionNature,@ModuleType";
return(_context.ExecuteStoreCommand(SP_SQL, Id_, OCode_, Company_Code_, ItemCode_, ItemName_, LedgerCode_, LedgerName_, ModuleId_, ModuleName_, TransactionNature_, ModuleType_));
}
}
catch (Exception)
{
throw;
}
}
//for sales User Summary post
internal int Sync_SalesSummary(string OCode, string SaleType, string VoucherDate, string EditUser, Double ItemTotal)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var OCode_ = new SqlParameter("@OCode", OCode);
var SaleType_ = new SqlParameter("@SaleType", SaleType);
var VoucherDate_ = new SqlParameter("@VoucherDate", VoucherDate);
var EditUser_ = new SqlParameter("@EditUser", EditUser);
var ItemTotal_ = new SqlParameter("@ItemTotal", ItemTotal);
string SP_SQL = "EPO_Sync_UserSales_Summary @OCode,@SaleType,@VoucherDate,@EditUser,@ItemTotal";
return(_context.ExecuteStoreCommand(SP_SQL, OCode_, SaleType_, VoucherDate_, EditUser_, ItemTotal_));
}
}
catch (Exception)
{
throw;
}
}
protected void BtnApprove_Click(object sender, EventArgs e)
{
try
{
var ParamempID1 = new SqlParameter("@VoucherNo", txtVoucherNo.Text);
var ParamempID2 = new SqlParameter("@Voucher_Date", txtVoucherDate.Text);
var ParamempID3 = new SqlParameter("@Approve_UserID", Edit_User);
var ParamempID4 = new SqlParameter("@Edit_User", Edit_User);
var ParamempID5 = new SqlParameter("@Company_Code", CompanyCode);
var ParamempID6 = new SqlParameter("@OCode", OCode);
string SP_SQL = "Vch_Enter_AC_VoucherApproval @VoucherNo,@Voucher_Date,@Approve_UserID,@Edit_User,@Company_Code,@OCode";
_context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5, ParamempID6);
//ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Voucher Number " + txtVoucherNo.Text + " Approved')", true);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Voucher Approved Successfully')", true);
grvVoucherDetails.DataSource = aVoucher_Bll.GetAllVoucherDetail(approval, txtVoucherNo.Text, CompanyCode, OCode);
grvVoucherDetails.DataBind();
}
catch
{
}
}
