public static List <DashboardModel> FetchPOSMonthlyActualReport()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_MONTHLY_COUNT.P_OUTTBL, OracleType.Cursor));
param[Common.POS_MONTHLY_COUNT.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liPOSMonthlyPlan = (List <DashboardModel>)OracleHelper.FetchData <DashboardModel>(Oraparam, Common.Queries.POS_SP_MONTHLY_ACTUAL_REPORT, EnumCommand.DataSource.list).DataSource.Data;
return(liPOSMonthlyPlan);
}
// public SelectList siSelectedList { get; set; }
#endregion
#region CompanyMaster Methods
public static List <CompanyMaster> FetchCompanyMaster()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liCompanyMaster = (List <CompanyMaster>)OracleHelper.FetchData <CompanyMaster>(Oraparam, Common.Queries.CMS_SP_GET_COMPANTY_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liCompanyMaster);
}
public static List <UserMaster> GetTVSCSAreaList()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liTVSCSAreaCode = (List <UserMaster>)OracleHelper.FetchData <UserMaster>(Oraparam, Common.Queries.CMS_SP_GET_AREACODE_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liTVSCSAreaCode);
}
public static List <ProductMaster> GetProductList()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_PRODUCT_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liProductMaster = (List <ProductMaster>)OracleHelper.FetchData <ProductMaster>(Oraparam, Common.Queries.CMS_SP_GET_PRODUCT_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liProductMaster);
}
public static List <YardMaster> FetchYardMaster(YardMaster objModel)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_GET_YARD_CODE.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_GET_YARD_CODE.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liYardMaster = (List <YardMaster>)OracleHelper.FetchData <YardMaster>(Oraparam, Common.Queries.POS_SP_GET_YARD_CODE, EnumCommand.DataSource.list).DataSource.Data;
return(liYardMaster);
}
public static List <BankMaster> FetchBankMasterBankType(BankMaster objBankdet)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_GET_GCM_DET.P_IN_CODE, objBankdet.KEY));
param.Add(new OracleParameter(Common.POS_SP_GET_GCM_DET.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_GET_GCM_DET.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var dafdafs = (List <BankMaster>)OracleHelper.FetchData <BankMaster>(Oraparam, Common.Queries.POS_SP_GET_GCM_DET, EnumCommand.DataSource.list).DataSource.Data;
return(dafdafs);
}
public static List <UserMaster> GetRoleList()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_USER_MANAGER.E_KEY, Common.Keys.RoleKey));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liRoleList = (List <UserMaster>)OracleHelper.FetchData <UserMaster>(Oraparam, Common.Queries.CMS_SP_GET_ROLE_LIST, EnumCommand.DataSource.list).DataSource.Data;
return(liRoleList);
}
public static List <EmployeeMaster> GetEmployeeList()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_GET_EMP_MAST.P_KEY, Common.Keys.GENERAL));
param.Add(new OracleParameter(Common.POS_SP_GET_EMP_MAST.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_GET_EMP_MAST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liEmployeeList = (List <EmployeeMaster>)OracleHelper.FetchData <EmployeeMaster>(Oraparam, Common.Queries.POS_SP_GET_EMP_MAST, EnumCommand.DataSource.list).DataSource.Data;
return(liEmployeeList);
}
public static List <Branch> FetchBranchCode(UserDetails objUserDetails)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_FETCH_BRANCH.P_USERID, objUserDetails.E_USER_ID));
param.Add(new OracleParameter(Common.POS_SP_FETCH_BRANCH.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_FETCH_BRANCH.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liBranch = (List <Branch>)OracleHelper.FetchData <Branch>(Oraparam, Common.Queries.POS_SP_FETCH_BRANCH, EnumCommand.DataSource.list).DataSource.Data;
return(liBranch);
}
public static List <BankMaster> FetchBankMasterByZoneKey(BankMaster bankmaster)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_KEY, bankmaster.KEY));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_RESULT_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liBankMaster = (List <BankMaster>)OracleHelper.FetchData <BankMaster>(Oraparam, Common.Queries.CMS_SP_GET_BANKZONREG_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liBankMaster);
}
public static List <RoleMaster> SaveRoleMaster(string XMLString)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.E_KEY, XMLString));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_RESULT_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_RESULT_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liRoleMaster = (List <RoleMaster>)OracleHelper.FetchData <RoleMaster>(Oraparam, Common.Queries.CMS_SP_INSERT_RESULT_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liRoleMaster);
}
public static List <RoleMaster> FetchRoleMasterByRole(RoleMaster rolemaster)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_FETCH_ROLE_LIST.E_ROLE_ID, rolemaster.ROLE_ID));
param.Add(new OracleParameter(Common.POS_SP_FETCH_ROLE_LIST.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_FETCH_ROLE_LIST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liRoleMaster = (List <RoleMaster>)OracleHelper.FetchData <RoleMaster>(Oraparam, Common.Queries.POS_SP_FETCH_MENU_BY_ROLE_ID, EnumCommand.DataSource.list).DataSource.Data;
return(liRoleMaster);
}
public static List <ActionMaster> FetchActionCodeAndDesc()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.E_KEY, Common.ActiveLog.Inverse));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liActionMaster = (List <ActionMaster>)OracleHelper.FetchData <ActionMaster>(Oraparam, Common.Queries.CMS_SP_GET_ACTION_LIST, EnumCommand.DataSource.list).DataSource.Data;
return(liActionMaster);
}
public static List <User> UpdateLastLogin(User user)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_FETCH_BRANCH.P_USERID, user.USER_ID));
param.Add(new OracleParameter(Common.POS_SP_FETCH_BRANCH.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_FETCH_BRANCH.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liUser = (List <User>)OracleHelper.FetchData <User>(Oraparam, Common.Queries.POS_SP_UPDATE_LAST_LOGIN, EnumCommand.DataSource.list).DataSource.Data;
return(liUser);
}
public static List <RegionMaster> FetchRegionMaster(RegionMaster objModel)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_LIST.E_KEY, objModel.KEY));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_LIST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_REGZONCOLLECTION_LIST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liRegionMaster = (List <RegionMaster>)OracleHelper.FetchData <RegionMaster>(Oraparam, Common.Queries.CMS_SP_REGZONCOLLECTION_LIST, EnumCommand.DataSource.list).DataSource.Data;
return(liRegionMaster);
}
public static List <MenuItems> FetchUserMenu(UserDetails objUserDetails)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter("E_USERID", objUserDetails.E_USER_ID));
param.Add(new OracleParameter("P_OUTTBL1", OracleType.Cursor));
param["P_OUTTBL1"].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liUserMenu = (List <MenuItems>)OracleHelper.FetchData <MenuItems>(Oraparam, Common.Queries.CMS_SP_FETCH_MENUS_USER_WISE, EnumCommand.DataSource.list).DataSource.Data;
return(liUserMenu);
}
public static List <BankMaster> FetchBankBranchMasterRegionZoneStateBankType(BankMaster objBankdet)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_LIST.E_KEY, objBankdet.DROPDOWNKEY));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_LIST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_REGZONCOLLECTION_LIST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var dafdafs = (List <BankMaster>)OracleHelper.FetchData <BankMaster>(Oraparam, Common.Queries.CMS_SP_REGZONCOLLECTION_LIST, EnumCommand.DataSource.list).DataSource.Data;
return(dafdafs);
}
public static List <User> FetchExternalUserDetails(UserDetails objUserDetails)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_USER_MANAGER.E_USER_ID, objUserDetails.E_USER_ID));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_USER_MANAGER.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liBranch = (List <User>)OracleHelper.FetchData <User>(Oraparam, Common.Queries.CMS_SP_CHECK_EXTERNAL_USER, EnumCommand.DataSource.list).DataSource.Data;
return(liBranch);
}
public static List <Notifications> GetOverAllNotifications(Notifications objnotifications)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter("P_USERID", objnotifications.USER_ID));
param.Add(new OracleParameter("P_ROLE_CODE", objnotifications.ROLE));
param.Add(new OracleParameter("P_OUTTBL", OracleType.Cursor));
param["P_OUTTBL"].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liNotification = (List <Notifications>)OracleHelper.FetchData <Notifications>(Oraparam, Common.Queries.POS_SP_OVERALL_NOTIFICATION, EnumCommand.DataSource.list).DataSource.Data;
return(liNotification);
}
public static List <AreaMaster> FetchAreaMaster()
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_GET_AREAREGION_DTLS.P_AREA_CODE, ""));
param.Add(new OracleParameter(Common.POS_SP_GET_AREAREGION_DTLS.P_REGION_CODE, ""));
param.Add(new OracleParameter(Common.POS_SP_GET_AREAREGION_DTLS.P_AREA_NAME, ""));
param.Add(new OracleParameter(Common.POS_SP_GET_AREAREGION_DTLS.P_OUTTBL, OracleType.Cursor));
param[Common.POS_SP_GET_AREAREGION_DTLS.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liAreaMaster = (List <AreaMaster>)OracleHelper.FetchData <AreaMaster>(Oraparam, Common.Queries.POS_SP_GET_AREAREGION_DTLS, EnumCommand.DataSource.list).DataSource.Data;
return(liAreaMaster);
}
public static List <DashboardModel> FetchPOSMonthlyCount(DashboardModel DashboardModel)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_MONTHLY_COUNT.P_USER_ROLE, HttpContext.Current.Session[Common.SESSION_VARIABLES.ROLE_CODE].ToString()));
param.Add(new OracleParameter(Common.POS_MONTHLY_COUNT.P_USER_ID, HttpContext.Current.Session[Common.SESSION_VARIABLES.USER_ID].ToString()));
param.Add(new OracleParameter(Common.POS_MONTHLY_COUNT.P_MONTH, DashboardModel.MONTH_YEAR));
param.Add(new OracleParameter(Common.POS_MONTHLY_COUNT.P_OUTTBL, OracleType.Cursor));
param[Common.POS_MONTHLY_COUNT.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liCompanyMaster = (List <DashboardModel>)OracleHelper.FetchData <DashboardModel>(Oraparam, Common.Queries.POS_SP_MONTHLY_COUNT, EnumCommand.DataSource.list).DataSource.Data;
return(liCompanyMaster);
}
public static List <ActionMaster> SaveActionMaster(ActionMaster actionmaster)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.E_KEY, actionmaster.KEY));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.E_ACTION_CODE, actionmaster.ACTION_CODE));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.E_ACTION_DESC, actionmaster.ACTION_DESC));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.E_ACTIVE, actionmaster.USER_ACTIVE));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_ACTION_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_ACTION_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liActionMaster = (List <ActionMaster>)OracleHelper.FetchData <ActionMaster>(Oraparam, Common.Queries.CMS_SP_INSERT_ACTION_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liActionMaster);
}
public static List <Notifications> UpdateNotifications(string sUserId, string sRole, string sNotificationId, string sIsBulk)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter("P_USER_ID", sUserId));
param.Add(new OracleParameter("P_ROLE_CODE", sRole));
param.Add(new OracleParameter("P_NOTIFICATION_ID", sNotificationId));
param.Add(new OracleParameter("P_IS_BULK", sIsBulk));
param.Add(new OracleParameter("P_OUTTBL", OracleType.Cursor));
param["P_OUTTBL"].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liNotification = (List <Notifications>)OracleHelper.FetchData <Notifications>(Oraparam, Common.Queries.POS_SP_UPDATE_NOTIFICATION, EnumCommand.DataSource.list).DataSource.Data;
return(liNotification);
}
public static List <BillingMaster> FetchBillingMasterHRD(BillingMaster billingmaster)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_GET_BILLING_MASTER.P_KEY_CODE, billingmaster.KEY));
param.Add(new OracleParameter(Common.POS_SP_GET_BILLING_MASTER.P_BANK_ID, billingmaster.BANK_ID));
param.Add(new OracleParameter(Common.POS_SP_GET_BILLING_MASTER.P_CHRG_TYPE, billingmaster.CHARGE_TYPE));
param.Add(new OracleParameter(Common.POS_SP_GET_BILLING_MASTER.P_PRODUCT, billingmaster.PRODUCT_ID));
param.Add(new OracleParameter(Common.POS_SP_GET_BILLING_MASTER.P_OUT_TBL, OracleType.Cursor));
param[Common.POS_SP_GET_BILLING_MASTER.P_OUT_TBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liBillingMaster = (List <BillingMaster>)OracleHelper.FetchData <BillingMaster>(Oraparam, Common.Queries.POS_SP_GET_BILLING_MASTER, EnumCommand.DataSource.list).DataSource.Data;
return(liBillingMaster);
}
public static List <Notifications> GetAllNotifications(string LoginID, string sUserRole, string sLastLogin, string sIsNewUser)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter("P_USERID", LoginID));
param.Add(new OracleParameter("P_ROLE_CODE", sUserRole));
param.Add(new OracleParameter("P_LAST_LOGIN", sLastLogin));
param.Add(new OracleParameter("P_IS_NEW_USER", sIsNewUser));
param.Add(new OracleParameter("P_OUTTBL", OracleType.Cursor));
param["P_OUTTBL"].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liNotification = (List <Notifications>)OracleHelper.FetchData <Notifications>(Oraparam, Common.Queries.POS_SP_ALL_NOTIFICATION, EnumCommand.DataSource.list).DataSource.Data;
return(liNotification);
}
public static List <BankMaster> SaveBankMaster(BankMaster bankmaster)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.POS_SP_INS_BANK_MASTER.P_KEY, bankmaster.KEY));
param.Add(new OracleParameter(Common.POS_SP_INS_BANK_MASTER.P_BANK_NAME, bankmaster.BANK_DESC));
param.Add(new OracleParameter(Common.POS_SP_INS_BANK_MASTER.P_BANK_CODE, bankmaster.BANK_CODE));
param.Add(new OracleParameter(Common.POS_SP_INS_BANK_MASTER.P_BANK_TYPE, bankmaster.BANK_TYPE));
param.Add(new OracleParameter(Common.POS_SP_INS_BANK_MASTER.P_ACTIVE, bankmaster.BANK_ACTIVE));
param.Add(new OracleParameter(Common.POS_SP_INS_BANK_MASTER.P_OUT, OracleType.Cursor));
param[Common.POS_SP_INS_BANK_MASTER.P_OUT].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liBankMaster = (List <BankMaster>)OracleHelper.FetchData <BankMaster>(Oraparam, Common.Queries.POS_SP_INS_BANK_MASTER, EnumCommand.DataSource.list).DataSource.Data;
return(liBankMaster);
}
public static List <ProductMaster> SaveProductMaster(ProductMaster ProductMaster, string UserID)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.E_KEY, ProductMaster.KEY));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.E_PRODUCT_CODE, ProductMaster.PRODUCT_CODE));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.E_PRODUCT_DESC, ProductMaster.PRODUCT_DESC));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.E_CREATED_BY, UserID));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.E_UPDATED_BY, UserID));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.E_ACTIVE, ProductMaster.PRODUCT_ACTIVE));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_PRODUCT_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_COMPANY_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liProductMaster = (List <ProductMaster>)OracleHelper.FetchData <ProductMaster>(Oraparam, Common.Queries.CMS_SP_INSERT_PRODUCT_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liProductMaster);
}
public static List <ZonalMaster> SaveZonalMaster(ZonalMaster ZonalMaster, string UserID)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_KEY, ZonalMaster.KEY));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CODE, ZonalMaster.ZONE_CODE));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CODE_DESC, ZonalMaster.ZONE_DESC));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_ACTIVE, ZonalMaster.USER_ACTIVE));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_ZONE_CODE, null));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CREATED_BY, UserID));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_REGZONCOLLECTION_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liZonalMaster = (List <ZonalMaster>)OracleHelper.FetchData <ZonalMaster>(Oraparam, Common.Queries.CMS_SP_REGZONCOLLECTION_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liZonalMaster);
}
public static List <CompanyMaster> SaveCompanyMaster(CompanyMaster companymaster)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.E_KEY, companymaster.KEY));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.E_COMPANY_CODE, companymaster.COMPANY_CODE));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.E_COMPANY_DESC, companymaster.COMPANY_NAME));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.E_CREATED_BY, companymaster.CREATED_BY));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.E_COMPANY_UPDATE_BY, companymaster.UPDATED_BY));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.E_ACTIVE, companymaster.COMP_ACTIVE));
param.Add(new OracleParameter(Common.CMS_SP_INSERT_COMPANY_MST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_INSERT_COMPANY_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liCompanyMaster = (List <CompanyMaster>)OracleHelper.FetchData <CompanyMaster>(Oraparam, Common.Queries.CMS_SP_INSERT_COMPANY_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liCompanyMaster);
}
public static List <RegionMaster> SaveRegionMaster(RegionMaster regionmaster)
{
OracleParameterCollection param1 = new OracleParameterCollection();
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_KEY, regionmaster.KEY));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CODE, regionmaster.REGION_CODE));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CODE_DESC, regionmaster.REGION_DESC));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_ACTIVE, regionmaster.ACTIVE));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_ZONE_CODE, regionmaster.ZONE_CODE));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CREATED_BY, regionmaster.CREATED_BY));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.P_OUTTBL, OracleType.Cursor));
param1[Common.CMS_SP_REGZONCOLLECTION_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam1 = new OracleParameter[param1.Count];
param1.CopyTo(Oraparam1, 0);
param1.Clear();
var liRegionMaster1 = (List <RegionMaster>)OracleHelper.FetchData <RegionMaster>(Oraparam1, Common.Queries.CMS_SP_REGZONCOLLECTION_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liRegionMaster1);
}