public IEnumerable <Complaint> GetComplaintsDetails(string id, string status) { string Sql = @"select new_name,new_contracttype,new_problemcase,new_compalinsource ,new_cshindivcontractid,new_problemdetails ,new_HIndvContract.new_HIndivClintnameName,new_HIndvContract.new_HIndivClintname ,dateadd (hh,3,new_csindvsector.CreatedOn) ,CONVERT(VARCHAR(20),dateadd(hh, 3, new_csindvsector.CreatedOn ),103) as edate,FORMAT(CAST(dateadd(hh, 3, new_csindvsector.CreatedOn ) AS DATETIME),'hh:mm tt') as etime,new_csindvsector.statuscode ,new_HIndvContract.new_ContractNumber from new_csindvsector,new_HIndvContract where new_csindvsector.new_cshindivcontractid=new_HIndvContract.new_HIndvContractId and new_HIndvContract.new_HIndivClintname='@id' and new_csindvsector.statuscode='@stat' order by new_csindvsector.CreatedOn desc"; Sql = Sql.Replace("@id", id); Sql = Sql.Replace("@stat", status); DataTable dt = CRMAccessDB.SelectQ(Sql).Tables[0]; List <Complaint> List = new List <Complaint>(); for (int i = 0; i < dt.Rows.Count; i++) { List.Add(new Complaint { Code = dt.Rows[i]["new_name"].ToString(), Category = OptionsController.GetName("new_csindvsector", "new_contracttype", 1025, dt.Rows[i]["new_contracttype"].ToString()), Type = OptionsController.GetName("new_csindvsector", "new_problemcase", 1025, dt.Rows[i]["new_problemcase"].ToString()), Date = dt.Rows[i]["edate"].ToString(), Time = dt.Rows[i]["etime"].ToString(), Description = dt.Rows[i]["new_problemdetails"].ToString(), CustomerName = dt.Rows[i]["new_HIndivClintnameName"].ToString(), Status = OptionsController.GetName("new_csindvsector", "statuscode", 1025, dt.Rows[i]["statuscode"].ToString()), ContractNumber = dt.Rows[i]["new_ContractNumber"].ToString(), }); } return(List); }
public IEnumerable <IndivPricing> GetPricingByNationality(string id) { string SQL = @"select new_indvprice.new_indvpriceId,new_indvprice.new_pricename, new_indvprice.new_nationalityName,new_indvprice.new_contractmonths,new_indvprice.new_monthlypaid,new_indvprice.new_periodamount ,new_indvprice.new_everymonth,new_indvprice.new_pricenumber,new_indvprice.new_pricetype,new_nationality,new_prepaid from new_indvprice where new_nationality='@id'"; SQL = SQL.Replace("@id", id); DataTable dt = CRMAccessDB.SelectQ(SQL).Tables[0]; List <IndivPricing> List = new List <IndivPricing>(); for (int i = 0; i < dt.Rows.Count; i++) { List.Add(new IndivPricing() { Id = dt.Rows[i]["new_indvpriceId"].ToString(), Name = dt.Rows[i]["new_pricename"].ToString(), Number = dt.Rows[i]["new_pricenumber"].ToString(), NationalityName = dt.Rows[i]["new_nationalityName"].ToString(), TypeId = dt.Rows[i]["new_pricetype"].ToString(), TypeName = OptionsController.GetName("new_indvprice", "new_pricetype", 1025, dt.Rows[i]["new_pricetype"].ToString()), ContractMonths = MathNumber.RoundDeciaml(dt.Rows[i]["new_contractmonths"].ToString()), PeriodAmount = MathNumber.RoundDeciaml(dt.Rows[i]["new_periodamount"].ToString()), EveryMonth = MathNumber.RoundDeciaml(dt.Rows[i]["new_everymonth"].ToString()), MonthelyPaid = MathNumber.RoundDeciaml(dt.Rows[i]["new_monthlypaid"].ToString()), PrePaid = MathNumber.RoundDeciaml(dt.Rows[i]["new_monthlypaid"].ToString()), }); } return(List);; }
public BusinessSector GetOnLoadData(int lang = 0) { NationalityController = new NationalityController(); ProfessionsController = new ProfessionsController(); CityController = new CityController(); BusinessSector = new BusinessSector(); Sectors = new OptionsController(); BusinessSector.Nationality = NationalityController.GetAllNationlity(lang); BusinessSector.Profession = ProfessionsController.GetAllProfessions(lang); BusinessSector.sectors = Sectors.GetSectors(0); return(BusinessSector); }
public string Create(string Company, int sector, string Description, string phone, int who = 1) { // select new_nationalityid,new_districtid,new_profrequiredid,new_cityid from lead // Entity Lead = new Entity("lead"); Lead["new_sector"] = new OptionSetValue(1); Lead["companyname"] = Company; Lead["firstname"] = " طلب قطاع اعمال لشركة" + Company; Lead["new_company_busienss"] = OptionsController.GetName("account", "industrycode", 1025, sector.ToString()); // Lead["new_companysector"] = new OptionSetValue(sector); Lead["mobilephone"] = phone; Lead["description"] = Description; Guid id = GlobalCode.Service.Create(Lead); return(id.ToString()); }