/// <summary>
/// Logs an error to the database.
/// </summary>
/// <remarks>
/// Use the stored procedure called by this implementation to set a
/// policy on how long errors are kept in the log. The default
/// implementation stores all errors for an indefinite time.
/// </remarks>
public override string Log(Error error)
{
if (error == null)
{
throw new ArgumentNullException("error");
}
string errorXml = ErrorXml.EncodeString(error);
Guid id = Guid.NewGuid();
using (OracleConnection connection = new OracleConnection(this.ConnectionString))
using (OracleCommand command = connection.CreateCommand())
{
connection.Open();
using (OracleTransaction transaction = connection.BeginTransaction())
{
// because we are storing the XML data in a NClob, we need to jump through a few hoops!!
// so first we've got to operate within a transaction
command.Transaction = transaction;
// then we need to create a temporary lob on the database server
command.CommandText = "declare xx nclob; begin dbms_lob.createtemporary(xx, false, 0); :tempblob := xx; end;";
command.CommandType = CommandType.Text;
OracleParameterCollection parameters = command.Parameters;
parameters.Add("tempblob", OracleType.NClob).Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
// now we can get a handle to the NClob
OracleLob xmlLob = (OracleLob)parameters[0].Value;
// create a temporary buffer in which to store the XML
byte[] tempbuff = Encoding.Unicode.GetBytes(errorXml);
// and finally we can write to it!
xmlLob.BeginBatch(OracleLobOpenMode.ReadWrite);
xmlLob.Write(tempbuff, 0, tempbuff.Length);
xmlLob.EndBatch();
command.CommandText = SchemaOwner + "pkg_elmah$log_error.LogError";
command.CommandType = CommandType.StoredProcedure;
parameters.Clear();
parameters.Add("v_ErrorId", OracleType.NVarChar, 32).Value = id.ToString("N");
parameters.Add("v_Application", OracleType.NVarChar, _maxAppNameLength).Value = ApplicationName;
parameters.Add("v_Host", OracleType.NVarChar, 30).Value = error.HostName;
parameters.Add("v_Type", OracleType.NVarChar, 100).Value = error.Type;
parameters.Add("v_Source", OracleType.NVarChar, 60).Value = error.Source;
parameters.Add("v_Message", OracleType.NVarChar, 500).Value = error.Message;
parameters.Add("v_User", OracleType.NVarChar, 50).Value = error.User;
parameters.Add("v_AllXml", OracleType.NClob).Value = xmlLob;
parameters.Add("v_StatusCode", OracleType.Int32).Value = error.StatusCode;
parameters.Add("v_TimeUtc", OracleType.DateTime).Value = error.Time.ToUniversalTime();
command.ExecuteNonQuery();
transaction.Commit();
}
return(id.ToString());
}
}
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 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 <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 <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 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 <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 <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 <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 <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 <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 <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 <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 <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 <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);
}
// <Snippet1>
public void CreateOracleParamColl(OracleCommand command)
{
OracleParameterCollection paramCollection = command.Parameters;
paramCollection.Add("pDName", OracleType.VarChar);
paramCollection.Add("pLoc", OracleType.VarChar);
string parameterNames = "";
for (int i = 0; i < paramCollection.Count; i++)
{
parameterNames += paramCollection[i].ToString() + "\n";
}
Console.WriteLine(parameterNames);
paramCollection.Clear();
}
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 <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> 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 <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 <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);
}
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);
}
