public IHttpActionResult PutCategory(int id, DAL.Entities.Categories category) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != category.CategoryID) { return BadRequest(); } db.Entry(category).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CategoryExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }
public void Delete(DAL.Model.SubCategoria subcategoria) { var session = sessionFactory.OpenSession(); var tran = session.BeginTransaction(); try { IList<Model.SubCategoria> categorias = GetSubCategorias(subcategoria); if (categorias.Count > 0) { session.Delete(subcategoria); tran.Commit(); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { session.Close(); } }
public static Dictionary<String, List<LogMatrixDO>> GetByRowNumberGroupBySpecies(DAL cruiseDAL, string reportNum) { var dict = new Dictionary<string, List<LogMatrixDO>>(); var list = cruiseDAL.From<LogMatrixDO>() .Where("ReportNumber = ?") .Read(reportNum).ToList(); //.Read<LogMatrixDO>("WHERE ReportNumber = ?", (object)reportNum); foreach (LogMatrixDO lm in list) { if (dict.ContainsKey(lm.Species)) { dict[lm.Species].Add(lm); } else { var l = new List<LogMatrixDO>(); l.Add(lm); dict.Add(lm.Species, l); } } return dict; }
//public static Random _rand; public DALTest(ITestOutputHelper output) { _output = output; _testDALInstance = FMSCORM.Tests.CommonMethods.GetTestDAL(); Assert.True(_testDALInstance.Exists); }
public int insertloanCharge(String chargeName, double amount, String amountStatus, ArrayList loanTypeNo, int Status) { int id = 0; int resultInner = 0; DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "EXEC insertCharges @Status, @ChargeName, @Amount, @AmountStatus, @isArchived"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@Status", Status); parameters.Add("@ChargeName", chargeName); parameters.Add("@Amount", amount); parameters.Add("@AmountStatus", amountStatus); parameters.Add("@isArchived", 0); int result = Convert.ToInt32(dal.executeNonQuery(sql, parameters)); String sqlSelect = "Select ChargeId from CHARGES where isArchived=0 and ChargeName= " + "'" + chargeName + "'"; id = Convert.ToInt32(dal.executeScalar(sqlSelect)); if (result != 0) { foreach (int i in loanTypeNo) { String sqlInner = "INSERT INTO LOAN_TYPE_CHARGES VALUES (@LoanTypeId, @ChargeId)"; Dictionary<String, Object> parametersInner = new Dictionary<string, object>(); parametersInner.Add("@LoanTypeId", i); parametersInner.Add("@ChargeId", id); resultInner = Convert.ToInt32(dal.executeNonQuery(sqlInner, parametersInner)); } } return resultInner; }
public int insertFee(String feeDesc, Double feeAmount, ArrayList memberTypeNo, int Status) { int resultInner = 0; DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "EXEC insertFee @feeDesc, @Amount, @Status;"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@feeDesc", feeDesc); parameters.Add("@Amount", feeAmount); parameters.Add("@Status", Status); int result = Convert.ToInt32(dal.executeNonQuery(sql, parameters)); Object rs = dal.executeScalar("SELECT @@IDENTITY"); //problem area int id = int.Parse(rs.ToString()); if (id != 0) { foreach (int i in memberTypeNo) { String sqlInner = "INSERT INTO MEMBER_TYPE_FEE (MemberTypeNo, FeeId) VALUES (@memberTypeNo, @feeId)"; Dictionary<String, Object> parametersInner = new Dictionary<string, object>(); parametersInner.Add("@memberTypeNo", i); parametersInner.Add("@feeId", id); resultInner = Convert.ToInt32(dal.executeNonQuery(sqlInner, parametersInner)); } } return resultInner; }
public SqlServerCore(DAL.IDatabase databaseImplementation = null) { if (databaseImplementation == null) database = new DAL.SqlServerDatabase(); else database = databaseImplementation; }
public void DefaultChecklistTypesExistsTest() { using (var dal = new DAL<MainDbContext>()) { Assert.IsTrue(dal.DbContext.ChecklistTypes.Count() > 0); } }
internal PaymentStatusCode(DAL.PaymentStatusCode dalPaymentStatusCode) : this() { this.Id = dalPaymentStatusCode.Id; this.PaymentTransactionId = dalPaymentStatusCode.PaymentTransactionId; this.StatusCode = dalPaymentStatusCode.StatusCode; }
public DataSet SelectAllCapitalContribution() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "SELECT MinCapitalContributionId AS 'Minimum Capital Contribution ID', l.MemberTypeNo AS 'Member Type Id', Description AS 'Member Type', MinimumContribution AS 'Share Capital', Duration, l.Status, l.isArchived FROM MINIMUM_CAPITAL_CONTRIBUTION l INNER JOIN MEMBER_TYPE m ON l.MemberTypeNo = m.MemberTypeNo"; DataSet ds = dal.executeDataSet(sql); return ds; }
public DataSet selectAllMemberTypes() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "SELECT MemberTypeNo, Description FROM MEMBER_TYPE WHERE isArchived=0 and hasLoan=1"; DataSet ds = dal.executeDataSet(sql); return ds; }
public void CreateAndDeleteChecklistTest() { using (var dal = new DAL<MainDbContext>()) { var checklistCount = dal.DbContext.Checklists.Count(); var promouter = dal.Create<PrivateEmployer>( new PrivateEmployer { Email = "*****@*****.**" }, new SeoEntry { Keyword = "email domain", Title = "Mail", Description = "Send mail to some gays =))" }); var checklist = dal.CreateChecklist(promouter, new List<AttribValue>()); dal.DbContext.SaveChanges(); Assert.AreEqual(checklistCount + 2, dal.DbContext.Checklists.Count()); dal.DeleteById<Checklist>(dal.DbContext.Entry(checklist).Entity.Id); dal.DbContext.SaveChanges(); Assert.AreEqual(checklistCount+1, dal.DbContext.Checklists.Count()); } }
public static bool CheckUserPwd(DAL.SysMember user, string strPwd) { string enPass = Utilities.DESEncrypt(strPwd); return user != null && !string.IsNullOrEmpty(strPwd) && (Utilities.Compare(enPass, user.MemberPwd) || Utilities.Compare(strPwd, user.MemberPwd)); }
/// <summary> /// 获取最近一小时站点信息 /// </summary> /// <returns></returns> public static DataTable getOnetimegas() { DAL dal = new DAL(); string gas = ""; DataTable dt = new DataTable(); dt.Columns.Add("站点"); dt.Columns.Add("销售气量"); dt.Columns.Add("当班班组"); int n = 0; for (int i = 0; i < 2; i++)//循环3次,统计3个站点数据 { DataRow row = dt.NewRow(); n = i + 2; if (n == 2) { row["站点"] = "南高"; } if (n == 3) { row["站点"] = "西路"; } if (n == 4) { row["站点"] = "麻柳沱"; } gas = dal.RunSqlGetID("SELECT sum([NowGas]) as 气量 FROM [CSERVER].[dbo].[tempGAS] where StationNO =" + n.ToString() + " and TradeDate > dateadd(hh,-1,getdate()) "); if (gas == null) { gas = "0"; } row["销售气量"] = gas; row["当班班组"] = dal.RunSqlGetID("SELECT top 1 [BZNO] FROM [CSERVER].[dbo].[DateSum] where StationNO=" + n.ToString() + " ORDER BY SxBTime DESC"); dt.Rows.Add(row); } return dt; }
public int insertSavingsTransaction() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "EXEC insertSavingsTransaction @SavingsAccountNo, @TransactionMode, @Amount, @Representative, @SavingsPassbook"; Dictionary<String, Object> parameters = new Dictionary<string, object>(); parameters.Add("@SavingsAccountNo", this.AccountNo); parameters.Add("@TransactionMode", this.TransactionMode); parameters.Add("@Amount", this.Amount); parameters.Add("@Representative", this.Representative); parameters.Add("@SavingsPassbook", this.PassbookNo); int result = Convert.ToInt32(dal.executeNonQuery(sql, parameters)); if (result == 1) { if (this.TransactionMode == "Withdraw") { String sql2 = "UPDATE SAVINGS_ACCOUNT SET Balance = Balance - @Amount WHERE SavingsAccountNo = @SavingsAccountNo"; Dictionary<String, Object> parameters2 = new Dictionary<string, object>(); parameters2.Add("@SavingsAccountNo", this.AccountNo); parameters2.Add("@Amount", this.Amount); dal.executeNonQuery(sql2, parameters2); } else if (this.TransactionMode == "Deposit") { String sql2 = "UPDATE SAVINGS_ACCOUNT SET Balance = Balance + @Amount WHERE SavingsAccountNo = @SavingsAccountNo"; Dictionary<String, Object> parameters2 = new Dictionary<string, object>(); parameters2.Add("@SavingsAccountNo", this.AccountNo); parameters2.Add("@Amount", this.Amount); dal.executeNonQuery(sql2, parameters2); } } return result; }
public void Delete(DAL.Model.Produto produto) { var session = sessionFactory.OpenSession(); var tran = session.BeginTransaction(); try { IList<Model.Produto> produtos = GetProdutos(produto); if (produtos.Count > 0) { session.Delete(produto); tran.Commit(); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { session.Close(); } }
/// <summary> /// 通过姓名搜索DKP信息 /// </summary> /// <param name="context"></param> public void DKP_sc_info(HttpContext context) { string name = context.Request["name"]; string SQL = "SELECT TOP 10 [日期],[积分],[说明] FROM [CNGTZ].[dbo].[TZ_人员_积分] where 姓名=@姓名 ORDER BY 日期 desc"; string info = " {\"top\":@top@,\"row\":@row@}"; string row = "[]", top = "[]"; DAL dal = new DAL(); SqlParameter par1 = new SqlParameter("姓名", name.Trim()); DataTable dt = dal.RunSqlDataTable(SQL, new SqlParameter[] { par1 }); if (dt != null) { row = Json.TableToJson(dt); } SQL = @"SELECT a.[姓名],isnull(b.累计,0) as 累计,isnull(c.消费,0)as 消费,isnull(d.当前,0)as 当前 FROM [CNGTZ].[dbo].[TZ_人员] a LEFT JOIN ( SELECT [姓名],sum([积分]) as 当前 FROM [CNGTZ].[dbo].[TZ_人员_积分] group BY 姓名 ) d ON a.姓名=d.姓名 LEFT JOIN ( SELECT [姓名],sum([积分]) as 累计 FROM [CNGTZ].[dbo].[TZ_人员_积分] where 积分>0 group BY 姓名 ) b ON a.姓名=b.姓名 LEFT JOIN ( SELECT [姓名],sum([积分]) as 消费 FROM [CNGTZ].[dbo].[TZ_人员_积分] where 积分<0 group BY 姓名 ) c ON a.姓名=c.姓名 WHERE a.姓名=@姓名"; dt = dal.RunSqlDataTable(SQL, new SqlParameter[] { par1 }); if (dt != null) { top = Json.TableToJson(dt); } info = info.Replace("@top@", top); info = info.Replace("@row@", row); context.Response.Write(info); }
public int Update(DAL.Model.Produto produto) { if (produto.Categorias != null && produto.Categorias.Id.Equals(0)) produto.Categorias = null; return repo.Update(produto); }
public DataSet selectMembers() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "Select m.AccountNo as 'Account No.', concat(m.FirstName,' ',m.MiddleName,' ',m.LastName) as 'Name', SUM(h.ShareCapital) AS 'Balance' from Member m inner join MEMBER_TYPE t on m.MemberTypeNo = t.MemberTypeNo full join MEMBER_SHARECAPITAL h on m.AccountNo = h.accountNo where m.Status = 1 and t.hasShareCapital = 1 group by m.AccountNo, m.FirstName, m.LastName, m.MiddleName"; DataSet ds = dal.executeDataSet(sql); return ds; }
public List<SubCategory> All() { try { List<SubCategory> objresult = new List<SubCategory>(); DAL DB = new DAL(ConnectionString); string sqlstring = "SELECT * FROM vwSubCategory"; DataSet DS = DB.GetDataSet(sqlstring, "TABLE1"); if (DS != null) { if (DS.Tables.Count > 0) { foreach (DataRow DR in DS.Tables[0].Rows) { SubCategory obj = GetObjectFromDR(DR); objresult.Add(obj); } } } return objresult; } catch (Exception ex) { throw ex; } }
/// <summary> /// 检查站点数据是否有错误数据 /// </summary> public void Checking(HttpContext context) { string SQL = @"SELECT 站点 as zd,b.简称 as 站点 ,[日期] ,[枪号] ,[流水号] ,[气量] ,[金额] ,[单价] ,[用户号] ,[卡名] ,[车类型] ,[车牌号] ,[消费方式] FROM [CNGQT].[dbo].[CNG_充装检查] left JOIN cngtz.dbo.TZ_站点 b ON 站点=b.ID where 卡名='班组卡' AND 消费方式<>'记帐金额'"; string row = "[]"; int n = 0; bool ok = false; string retext = "{\"ok\":@ok@,\"数量\":@数量@,\"row\":@row@}"; DAL dal = new DAL(); DataTable dt = dal.RunSqlDataTable(SQL); if (dt != null && dt.Rows.Count > 0) { ok = true; n = dt.Rows.Count; row = Json.TableToJson(dt); } retext = retext.Replace("@ok@", ok.ToString().ToLower()); retext = retext.Replace("@数量@", n.ToString()); retext = retext.Replace("@row@", row); context.Response.Write(retext); }
public DataSet selectMaximumWithdrawalAll() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "SELECT m.AccountTypeId AS 'Account Type Id', SavingsTypeName AS 'Account Type', MaximumWithdrawal AS 'Maximum Withdrawal', m.Status, isArchived, m.DateCreated AS 'Date Created', m.DateModified AS 'Last Modified' FROM MAXIMUM_WITHDRAWAL m INNER JOIN SAVINGS_ACCOUNT_TYPE s ON m.AccountTypeId = s.AccountTypeId"; DataSet ds = dal.executeDataSet(sql); return ds; }
// This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // /// <summary> /// Seeds the default context. /// </summary> /// <param name="context">The context.</param> public static void SeedContext(DAL.DefaultContext context) { DbSet<District> districtSet = context.Districts; FixDistricts(ref districtSet); DbSet<PhoneNumberPrefix> phoneNumberPrefixSet = context.PhoneNumberPrefixes; FixPhoneNumberPrefixes(ref phoneNumberPrefixSet); DbSet<Meeting> meetingSet = context.Meetings; if (context.MeetingTitleTypes.All(mtt => mtt.MeetingType != MeetingType.SetkaniTymu)) { DbSet<MeetingTitleType> meetingTitleTypeSet = context.MeetingTitleTypes; DbContext dbContext = context; FixMeetingTitleTypesAndMeetings(ref dbContext, ref meetingTitleTypeSet, ref meetingSet); } if (context.BankAccounts.Any(ba => ba.Token == "V2-1-0-21")) { DbSet<BankAccount> bankAccountSet = context.BankAccounts; FixBankAccountsAndMeetings(ref bankAccountSet, ref meetingSet); } context.SaveChanges(); if (context.UserProfiles.Any()) return; CreateAdminAccount("DefaultConnection"); }
public void getgas(HttpContext context) { string time1 = context.Request["time1"]; string time2 = context.Request["time2"]; DAL dal = new DAL(); DataTable dt = dal.RunSqlDataTable("EXECUTE [WebApp].[dbo].[CC_每小时气量分站点] '" + time1 + "','" + time2 + "'"); if (dt == null) { context.Response.Write("{}"); return; }; string str1 = "", str2 = "", str3 = "", str4 = ""; //double r1=0,r2=0,r3=0; int n = 0; foreach (DataRow dr in dt.Rows) { n++; str1 = str1 + dr["南高"].ToString() + ","; str2 = str2 + dr["西路"].ToString() + ","; str3 = str3 + dr["麻柳沱"].ToString() + ","; str4 = str4 + "\" " + n.ToString() + " \","; } str1 = str1.Substring(0, str1.Length - 1); str2 = str2.Substring(0, str2.Length - 1); str3 = str3.Substring(0, str3.Length - 1); str4 = str4.Substring(0, str4.Length - 1); string text = "{\"南高\":[" + str1 + "],\"西路\":[" + str2 + "],\"麻柳沱\":[" + str3 + "],\"x\":[" + str4 + "]}"; //Json.TableToJson(dt); context.Response.Write(text); }
public DataSet selectMember() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "SELECT AccountNo AS 'Account No', CONCAT(LastName, ', ', FirstName, ' ', MiddleName) AS 'Member Name', Description AS 'Member Type' FROM MEMBER m INNER JOIN MEMBER_TYPE mt ON m.MemberTypeNo = mt.MemberTypeNo WHERE m.Status=1"; DataSet ds = dal.executeDataSet(sql); return ds; }
public int checkIfLoanIsCollateralized(int loanTypeId) { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "Select isCollateral from LOAN_TYPE where LoanTypeId = " + "'" + loanTypeId + "'"; int isCollateral = Convert.ToInt32(dal.executeScalar(sql)); return isCollateral; }
public String checkSpouseName(String accountNo) { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "Select SpouseName from MEMBER WHERE AccountNo = " + "'" + accountNo + "'"; String spouse = Convert.ToString(dal.executeScalar(sql)); return spouse; }
public DataSet selectAccountTypes() { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "SELECT AccountTypeId, SavingsTypeName FROM SAVINGS_ACCOUNT_TYPE WHERE AccountTypeId NOT IN(SELECT AccountTypeId FROM MAXIMUM_WITHDRAWAL) AND isMaximumWithdrawal = 1 AND isArchived = 0"; DataSet ds = dal.executeDataSet(sql); return ds; }
public int checkIfLoanHasComakers(int loanTypeId) { DAL dal = new DAL(ConfigurationManager.ConnectionStrings["CMS"].ConnectionString); String sql = "Select CoMaker from LOAN_TYPE where LoanTypeId = " + "'" + loanTypeId + "'"; int comaker = Convert.ToInt32(dal.executeScalar(sql)); return comaker; }
/// <summary> /// Acutualiza un cause en la DB /// </summary> /// <param name="oCause"> Cause a actualizar</param> /// <returns></returns> public bool EditarRegistro(DAL.causes oCause) { try { //Recuperar el objeto a editar var oQuery = from q in oMedicuriEntities.causes. Where("it.idCause=@idCause", new ObjectParameter("idCause", oCause.idCause)) select q; DAL.causes oCauseOriginal = oQuery.First<DAL.causes>(); //Datos Cause oCauseOriginal.Clave = oCause.Clave; oCauseOriginal.Nombre = oCause.Nombre; oCauseOriginal.Conglomerado = oCause.Conglomerado; oCauseOriginal.Descripcion = oCause.Descripcion; oMedicuriEntities.SaveChanges(); return true; } catch { return false; } }
public List <StopBillingBO> GetBillableServicesForShortcode(int TelcoID, string Shortcode, bool showZeroPriceRec) { DAL objDAL = new DAL(connectionString); return(objDAL.GetBillableServicesForShortcode(TelcoID, Shortcode, showZeroPriceRec)); }
public DataSet GetDetailsOfAllLogins(int cpid, int amid, int ceid) { DAL objDAL = new DAL(connectionString); return(objDAL.GetDetailsOfAllLogins(cpid, amid, ceid)); }
public DataSet GetSubscriptionDetails(int Telcoid, string shortcode, string Keyword) { DAL objDAL = new DAL(connectionString); return(objDAL.GetSubscriptionDetails(Telcoid, shortcode, Keyword)); }
public bool InactiveShortcodeServices(int TelcoID, string Shortcode) { DAL objDAL = new DAL(connectionString); return(objDAL.InactiveShortcodeServices(TelcoID, Shortcode)); }
public List <StopServicesBO> GetActiveServicesForShortcode(int TelcoID, string Shortcode) { DAL objDAL = new DAL(connectionString); return(objDAL.GetActiveServicesForShortcode(TelcoID, Shortcode)); }
public int UpdateServicePrice(int telcoId, string shortcode, int serviceid, string serviceSourceType, string Price) { DAL objDB = new DAL(connectionString); return(objDB.UpdateServicePrice(telcoId, shortcode, serviceid, serviceSourceType, Price)); }
public bool StopBillingServicesForShortcode(int TelcoID, string Shortcode) { DAL objDAL = new DAL(connectionString); return(objDAL.StopBillingServicesForShortcode(TelcoID, Shortcode)); }
public List <MessageQueueDetails> GetAllDataToPostMessage(string MSISDN) { DAL objDB = new DAL(connectionString); return(objDB.GetAllDataToPostMessage(MSISDN)); }
public int UpdateFinanceCategory(int FinanceCatId, string Lookupids) { DAL objDAL = new DAL(connectionString); return(objDAL.UpdateFinanceCategory(FinanceCatId, Lookupids)); }
public List <MessageQueueDetails> GetAllRenewalFailedServiceMSISDNs(int Days) { DAL objDB = new DAL(connectionString); return(objDB.GetAllRenewalFailedServiceMSISDNs(Days)); }
public DataTable GetServiceTypes() { DAL objDAL = new DAL(connectionString); return(objDAL.GetServiceTypes()); }
public List <MessageQueueDetails> GetAllDataToPostMessage(int TelcoID, int Shortcode, string MSISDN, int ServiceID) { DAL objDB = new DAL(connectionString); return(objDB.GetAllDataToPostMessage(TelcoID, Shortcode, MSISDN, ServiceID)); }
public List <ChangeSubscriberServicesBO> GetKeywordsByShortcode_ContentDownload(string shortcode) { DAL objDAL = new DAL(connectionString); return(objDAL.GetKeywordsByShortcode_ContentDownload(shortcode)); }
public DataTable GetServiceDetailsByServiceType(string TelcoId, string shortcode, string ServiceType) { DAL objDAL = new DAL(connectionString); return(objDAL.GetServiceDetailsByServiceType(TelcoId, shortcode, ServiceType)); }
public List <ContentBO> GetContentDetails(string subscriptionId, string contentTypeId) { DAL objDB = new DAL(connectionString); return(objDB.GetContentDetails(subscriptionId, contentTypeId)); }
public int UpdateServiceName(int telcoId, string shortcode, int serviceid, string servicename) { DAL objDB = new DAL(connectionString); return(objDB.UpdateServiceName(telcoId, shortcode, serviceid, servicename)); }
public string GetServiceNameByKeyword(int TelcoId, string Shortcode, int ServiceId, string ServiceType) { DAL objDB = new DAL(connectionString); return(objDB.GetServiceNameByKeyword(TelcoId, Shortcode, ServiceId, ServiceType)); }
public DataTable GetFinanceCategories() { DAL objDB = new DAL(connectionString); return(objDB.GetFinanceCategories()); }
public UserBO GetUserDetails(int LoginID) { DAL objDB = new DAL(connectionString); return(objDB.GetUserDetails(LoginID)); }
public List <ContentBO> GetContentTypes() { DAL objDB = new DAL(connectionString); return(objDB.GetContentTypes()); }
public int InsertNewSubscriptionKeywords(string TotKeywords, string newKeyword, int lookupId, int subscriptionid, int languageid) { DAL objDB = new DAL(connectionString); return(objDB.InsertNewSubscriptionKeywords(TotKeywords, newKeyword, lookupId, subscriptionid, languageid)); }
public UserBO GetMICCUserDetails(string LoginName) { DAL objDB = new DAL(connectionString); return(objDB.GetMICCUserDetails(LoginName)); }
public string GetLookupkeywordsByServiceID(int telcoId, string shortcode, int serviceId) { DAL objDB = new DAL(connectionString); return(objDB.GetLookupkeywordsByServiceID(telcoId, shortcode, serviceId)); }
public DataSet GetServiceDetails(string shortcode, string keyword) { DAL objDB = new DAL(connectionString); return(objDB.GetServiceDetails(shortcode, keyword)); }
public DataSet GetChargeLogs(int telcoid, int CPID, string serviceID, string fromDate, string ToDate) { DAL objDB = new DAL(connectionString); return(objDB.GetChargeLogs(telcoid, CPID, serviceID, fromDate, ToDate)); }
public string GetInUseCommonLookupKeywords(string ShortCode, string Keywords, int TelcoID, int LookupID) { DAL objDB = new DAL(connectionString); return(objDB.GetInUseCommonLookupKeywords(ShortCode, Keywords, TelcoID, LookupID)); }
public DataSet Getdeletedsubscriber(string msisdn) { DAL objDB = new DAL(connectionString); return(objDB.Getdeletedsubscriber(msisdn)); }
public List <ChangeSubscriberServicesBO> GetkeywordsByServiceID(int serviceid) { DAL objDB = new DAL(connectionString); return(objDB.GetkeywordsByServiceID(serviceid)); }
public int updatesubscriber() { DAL objDB = new DAL(connectionString); return(objDB.updatesubscriber()); }
public int GetSMSPromoconfiguration(string colorbatch, string language, string shortcode, string messageText, string publishtime) { DAL objDB = new DAL(connectionString); return(objDB.GetSMSPromoconfiguration(colorbatch, language, shortcode, messageText, publishtime)); }