示例#1
0
        protected void PerformMove(string CID, string acout)
        {
            SqlConnection LAconn = new SqlConnection();
            var           conn   = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;

            LAconn.ConnectionString = conn;
            var comDal  = new CompanyDAL(conn);
            var OwnerId = acout;

            String     strSQLInsertStmt = "UPDATE dbo.Companies SET OwnershipAdminID = @OwnershipAdminID, AlteredDateTime=CURRENT_TIMESTAMP, OwnershipPeriod = NULL WHERE CompanyID =@CompanyID";
            SqlCommand LAcmd            = new SqlCommand(strSQLInsertStmt, LAconn);

            LAcmd.Parameters.AddWithValue("@OwnershipAdminID", OwnerId);
            LAcmd.Parameters.AddWithValue("@CompanyID", CID);
            try
            {
                LAconn.Open();
                LAcmd.ExecuteNonQuery();
                LAconn.Close();
            }
            catch (Exception ex)
            {
                Console.Write(ex.Message.ToString());
            }
        }
示例#2
0
        protected void performMove(String CID)
        {
            SqlConnection LAconn = new SqlConnection();
            var           conn   = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;

            LAconn.ConnectionString = conn;
            var comDal  = new CompanyDAL(conn);
            var OwnerId = comDal.CheckCompanyOwnerByID(CID);

            if (!string.IsNullOrEmpty(OwnerId))
            {
                String     strSQLInsertStmt = "UPDATE dbo.Companies SET OwnershipAdminID = @OwnershipAdminID, OwnershipPeriod = NULL WHERE CompanyID =@CompanyID";
                SqlCommand LAcmd            = new SqlCommand(strSQLInsertStmt, LAconn);
                LAcmd.Parameters.AddWithValue("@OwnershipAdminID", OwnerId);
                LAcmd.Parameters.AddWithValue("@CompanyID", CID);
                try
                {
                    LAconn.Open();
                    LAcmd.ExecuteNonQuery();
                    LAconn.Close();
                }
                catch (Exception ex)
                {
                    Console.Write(ex.Message.ToString());
                }
            }
        }
        private static void AllocateCompanyToRep(List <ComReAssign> coms, string mode, string numberofaccoutns,
                                                 string allocationPeriod, string allocrepId, string month, string year)
        {
            var repId = Convert.ToInt32(allocrepId);
            var listRecentAddedMoney = new List <DeltoneCRM_DAL.CompanyDAL.CompanyView>();

            if (repId > 0)
            {
                var alloceCompanies = DoFilterForCompany(coms, mode, month, year);
                var numberAccount   = Convert.ToInt32(numberofaccoutns);
                if (alloceCompanies.Count() < numberAccount)
                {
                    numberAccount = alloceCompanies.Count();
                }
                var allocTime   = GetAllocationTime(allocationPeriod);
                var currentDate = DateTime.Now;
                var connn       = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
                var comDal      = new CompanyDAL(connn);

                for (var i = 0; i < numberAccount; i++)
                {
                    var newHouseAccount = GetNewHouseCompany(alloceCompanies, repId);
                    if (newHouseAccount != null)
                    {
                        listRecentAddedMoney.Add(newHouseAccount);
                        comDal.InsertLead(newHouseAccount.CompanyID, repId, currentDate, allocTime);
                    }
                }
                // Session["recentAddedCompany"] = listRecentAddedMoney;
            }
        }
        private List <DeltoneCRM_DAL.CalendarEventDAL.CalendarEvent> GetLeadEventList(int userId, string sear)
        {
            var    eventsList  = new List <DeltoneCRM_DAL.CalendarEventDAL.CalendarEvent>();
            string cs          = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            var    leadComList = new CompanyDAL(cs).GetLeadCompanyNOExpires(userId);

            var callBackEvents = new CalendarEventDAL(cs).GetAllCAllBackEvents();

            callBackEvents = callBackEvents.OrderByDescending(x => x.start).ToList();
            foreach (var com in leadComList)
            {
                var eve = (from cl in callBackEvents where cl.companyId == com.CompanyId select cl).ToList();
                if (eve.Count > 0)
                {
                    eventsList.Add(eve[0]);
                }
            }

            if (!string.IsNullOrEmpty(sear))
            {
                eventsList = (from ec in eventsList
                              where ec.description.Contains(sear) ||
                              ec.title.Contains(sear)
                              select ec).ToList();
            }

            return(eventsList);
        }
        private DeltoneCRM_DAL.CompanyDAL.CompanyView GetNewCompaySel(List <DeltoneCRM_DAL.CompanyDAL.CompanyView> coViewAll,
                                                                      int repId)
        {
            string CONNSTRING      = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            var    comDal          = new CompanyDAL(CONNSTRING);
            var    listCompanylead = comDal.GetLeadCompaniesNotExist();

            Random rnd         = new Random();
            var    currentDate = DateTime.Now;
            var    pickedCom   = coViewAll.OrderBy(x => rnd.Next()).Take(1).ToList();

            if (pickedCom.Count > 0)
            {
                var pickedObj = pickedCom[0];
                if (listCompanylead.Any(x => x.CompanyId == pickedObj.CompanyID &&
                                        x.ExpiryDate.Date > currentDate.Date))
                {
                    return(GetNewCompaySel(coViewAll, repId));
                }
                //else
                //    if (listCompanylead.Any(x => x.CompanyId == pickedObj.CompanyID
                //   && x.UserId == repId))
                //    {
                //        return GetNewCompaySel(coViewAll, repId);
                //    }

                else
                {
                    return(pickedObj);
                }
            }
            return(null);
        }
示例#6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            lblError.Text = string.Empty;
            lblMsg.Text   = string.Empty;
            if (!IsPostBack)
            {
                CompanyDAL      newCompanyDal = new CompanyDAL();
                IList <Company> companies     = newCompanyDal.GetAllCompany();
                foreach (Company company in companies)
                {
                    ListItem item = new ListItem();
                    item.Text  = company.CompanyName;
                    item.Value = company.CompanyRegID.ToString();
                    ddlCompany.Items.Add(item);
                }

                TAFDAL newTAF = new TAFDAL();
                IList <TAFTemplate> templates = newTAF.GetAllTAFTemplates();
                foreach (TAFTemplate template in templates)
                {
                    ListItem item = new ListItem();
                    item.Text  = template.TemplateName;
                    item.Value = template.TemplateID.ToString();
                    ddlSelectTemplate.Items.Add(item);
                }
            }
        }
        private static DeltoneCRM_DAL.CompanyDAL.CompanyView GetNewHouseCompany(List <DeltoneCRM_DAL.CompanyDAL.CompanyView> coViewAll, int repId)
        {
            var    conn            = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            var    comDal          = new CompanyDAL(conn);
            var    listCompanylead = comDal.GetLeadCompanies();
            Random rnd             = new Random();
            var    currentDate     = DateTime.Now;
            var    pickedCom       = coViewAll.OrderBy(x => rnd.Next()).Take(1).ToList();

            if (pickedCom.Count > 0)
            {
                var pickedObj = pickedCom[0];
                if (listCompanylead.Any(x => x.CompanyId == pickedObj.CompanyID &&
                                        x.ExpiryDate.Date > currentDate.Date))
                {
                    return(GetNewHouseCompany(coViewAll, repId));
                }
                else
                if (listCompanylead.Any(x => x.CompanyId == pickedObj.CompanyID &&
                                        x.UserId == repId))
                {
                    return(GetNewHouseCompany(coViewAll, repId));
                }

                else
                {
                    return(pickedObj);
                }
            }
            return(null);
        }
示例#8
0
        public CompanyDetailsEntities GetCompanyDetails()
        {
            ICompanyDAL compDetials = new CompanyDAL();
            var         companyDAL  = compDetials.GetCompanyDetails();

            return(companyDAL);
        }
示例#9
0
        private void ReadWriteCSVFile()
        {
            string date = System.DateTime.Now.ToString("ddMMyyhhmmss");

            if (File.Exists(Server.MapPath(uppath)))
            {
                StreamReader          sr      = new StreamReader(Server.MapPath(uppath));
                StreamWriter          write   = new StreamWriter(Server.MapPath(output));
                CsvReader             csvread = new CsvReader(sr);
                CsvWriter             csw     = new CsvWriter(write);
                IEnumerable <Company> record  = csvread.GetRecords <Company>();

                foreach (var rec in record) // Each record will be fetched and printed on the screen
                {
                    csw.WriteRecord <Company>(rec);
                    csw.NextRecord();
                    CompanyDAL compdal = new CompanyDAL();
                    compdal.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
                    compdal.InsertCompany(rec);
                }
                sr.Close();
                write.Close();//close file streams

                if (File.Exists(Server.MapPath(uppath)))
                {
                    File.Delete(Server.MapPath(uppath));
                }
            }
        }
        public void AddNewMessagesCompanyIdTest()
        {
            CompanyDAL                companyDAL = new CompanyDAL();
            List <CompanyModel>       companies  = companyDAL.GetCompanies();
            MessagesFromBulidingModel model      = new MessagesFromBulidingModel();

            model.Subject   = "testSubject";
            model.Text      = "testText";
            model.Companies = companies;
            MessageDAL messageDAL = new MessageDAL();

            messageDAL.AddNewMessages(model);

            List <MessageToCompanyModel> messages = messageDAL.GetMessagesFromBuilding();

            int counter = 0;

            foreach (var item in companies)
            {
                if (messages.Where(x => x.Subject == "testSubject" && x.CompanyId == item.Id).FirstOrDefault() != null)
                {
                    counter++;
                }
            }

            Assert.That(counter == companies.Count, Is.True);
        }
示例#11
0
        private void AddAccount(List <DeltoneCRM_DAL.CompanyDAL.CompanyView> coViewAll)
        {
            var repId = Convert.ToInt32(RepNameDropDownList.SelectedValue);
            var listRecentAddedMoney = new List <DeltoneCRM_DAL.CompanyDAL.CompanyView>();

            if (repId > 0)
            {
                var    numberAccount = Convert.ToInt32(NumberAccountDropDownList.SelectedValue);
                var    allocTime     = GetAllocationTime();
                var    currentDate   = DateTime.Now;
                var    comDal        = new CompanyDAL(CONNSTRING);
                Random rnd           = new Random();
                for (var i = 0; i < numberAccount; i++)
                {
                    var newHouseAccount = GetNewHouseCompany(coViewAll, repId);
                    if (newHouseAccount != null)
                    {
                        listRecentAddedMoney.Add(newHouseAccount);
                        comDal.InsertLead(newHouseAccount.CompanyID, repId, currentDate, allocTime);
                    }
                }
                Session["recentAddedCompany"] = listRecentAddedMoney;
            }
            else
            {
                messagelable.Text = "Please Select Rep";
            }
        }
示例#12
0
        private DeltoneCRM_DAL.CompanyDAL.CompanyView GetNewHouseCompany(List <DeltoneCRM_DAL.CompanyDAL.CompanyView> coViewAll, int repId)
        {
            var    comDal          = new CompanyDAL(CONNSTRING);
            var    listCompanylead = comDal.GetLeadCompanies();
            Random rnd             = new Random();
            var    currentDate     = DateTime.Now;
            var    pickedCom       = coViewAll.OrderBy(x => rnd.Next()).Take(1).ToList();

            if (pickedCom.Count > 0)
            {
                var pickedObj = pickedCom[0];
                if (listCompanylead.Any(x => x.CompanyId == pickedObj.CompanyID))
                {
                    return(GetNewHouseCompany(coViewAll, repId));
                }
                else
                if (listCompanylead.Any(x => x.CompanyId == pickedObj.CompanyID &&
                                        x.UserId == repId))
                {
                    return(GetNewHouseCompany(coViewAll, repId));
                }

                else
                {
                    return(pickedObj);
                }
            }
            return(null);
        }
示例#13
0
        protected void Page_Load(object sender, EventArgs e)
        {
            PageSize = Convert.ToInt32(ddlPageSize.SelectedValue);
            gvEmailSchedule.PageSize = PageSize;
            if (!IsPostBack)
            {
                CompanyDAL      newCompanyDal = new CompanyDAL();
                IList <Company> companies     = newCompanyDal.GetAllCompany();
                foreach (Company company in companies)
                {
                    ListItem item = new ListItem();
                    item.Text  = company.CompanyName.Substring(0, company.CompanyName.Length > 45?45:company.CompanyName.Length);
                    item.Value = company.CompanyRegID.ToString();
                    ddlSearchCompany.Items.Add(item);
                }

                TAFDAL newTAF = new TAFDAL();
                IList <TAFTemplate> templates = newTAF.GetAllTAFTemplates();
                foreach (TAFTemplate template in templates)
                {
                    ListItem item = new ListItem();
                    item.Text  = template.TemplateName;
                    item.Value = template.TemplateID.ToString();
                    ddlSearchTemplate.Items.Add(item);
                }
            }
        }
示例#14
0
        public List <Company> getAllCompanies()
        {
            if (SafeUser != null && SafeUser.isLoggedIn())
            {
                try
                {
                    SqlHelper   helper = new SqlHelper();
                    SecurityDAL sdal   = new SecurityDAL(helper);
                    if (sdal.hasPermission(SafeUser.SignIN.UID, "SELECT"))
                    {
                        helper.Close();
                        helper = new SqlHelper();
                        CompanyDAL dal       = new CompanyDAL(helper);
                        var        companies = dal.getAllcompanies();
                        helper.Close();
                        return(companies);
                    }
                }catch (Exception ex)
                {
                    log(ex);
                }
            }

            return(null);
        }
示例#15
0
        protected void btnAddNewComp_Click(object sender, EventArgs e)
        {
            string confirmValue = Request.Form["confirm_value"];

            if (confirmValue == "Yes")
            {
                //this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You clicked YES!')", true);
            }
            else
            {
                // this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You clicked NO!')", true);
            }

            CompanyDAL compdal = new CompanyDAL();
            Company    com     = new Company();

            compdal.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
            com.Name    = tbAddCompany.Text;
            com.Country = tbAddCountry.Text;
            com.NameAr  = tbAddArname.Text;
            com.Site    = tbAddCompanytxt.Text;


            compdal.InsertCompany(com);
            gvCompany.EditIndex  = -1;
            tbAddCompany.Text    = string.Empty;
            tbAddCountry.Text    = string.Empty;
            tbAddArname.Text     = string.Empty;
            tbAddCompanytxt.Text = string.Empty;
            FillCompany();
        }
        private static void AddCompanies(List <DeltoneCRM_DAL.CompanyDAL.CompanyView> objLst,
                                         string numberOfAccount, string allocationPeriod, int RepId)
        {
            var    repId                 = RepId;
            string CONNSTRING            = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            var    listRecentAddedQuotes = new List <DeltoneCRM_DAL.CompanyDAL.CompanyView>();

            if (repId > 0)
            {
                var    numberAccount = Convert.ToInt32(numberOfAccount);
                var    allocTime     = GetAllocationTime(allocationPeriod);
                var    currentDate   = DateTime.Now;
                var    comDal        = new CompanyDAL(CONNSTRING);
                Random rnd           = new Random();
                for (var i = 0; i < numberAccount; i++)
                {
                    var newAccountQuote = GetNewCompaySel(objLst, repId);
                    if (newAccountQuote != null)
                    {
                        listRecentAddedQuotes.Add(newAccountQuote);
                        comDal.InsertLead(newAccountQuote.CompanyID, repId, currentDate, allocTime);
                    }
                }
            }
        }
        public void DeleteCompany()
        {
            CompanyDAL companyDAL = new CompanyDAL();
            int        companyId  = companyDAL.GetCompanies().Max(x => x.Id);

            companyDAL.DeleteCompany(companyId);
            Assert.True(companyDAL.GetCompanyById(companyId) == null);
        }
示例#18
0
        public bool AddCompany(CompanyDetailsEntities companyDetail)
        {
            ICompanyDAL addCompanyDAL = new CompanyDAL();
            var         companyDAL    = addCompanyDAL.AddCompanyDAL(companyDetail);
            var         abc           = companyDetail;

            return(companyDAL);
        }
示例#19
0
        public B2dCompany GetCompany(Int64 xid)
        {
            var comp = CompanyDAL.GetCompany(xid);

            //狀態語系文字對應
            comp.STATUS_DESC = GetFieldStatus(comp.STATUS);

            return(comp);
        }
示例#20
0
        public void FetchCompany()
        {
            CompanyDAL CompDAL = new CompanyDAL {
                ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
            };

            GVCompany.DataSource = CompDAL.GetCompany(null);
            GVCompany.DataBind();
        }
示例#21
0
        public static void DeleteField(string CompanyID, string ID, string FieldName, string TableType)
        {
            DataHelper.ExecuteQuerys("ALTER TABLE " + CompanyDAL.GetTableName(CompanyID, TableType) + " Drop column " + FieldName);
            FieldDAL.DeleteField(ID);
            string where = "CompanyID='{0}' and TableType ='{1}'";
            DataSet ds = FieldDAL.GetFieldList(string.Format(where, CompanyID, TableType));

            HttpContext.Current.Cache[Tools.GetCashName(CompanyID, TableType)] = ds;
        }
示例#22
0
        /// <summary>
        /// This method is used to get restricted list settings.
        /// </summary>
        /// <param name="sConnectionString"></param>
        /// <returns></returns>
        public RestrictedListSettingsDTO GetRestrictedListSettings(string sConnectionString)
        {
            List <CompanySettingConfigurationDTO> lstCompanySettingConfigurationDTO = null;
            RestrictedListSettingsDTO             objRestrictedListSettingsDTO      = null;

            try
            {
                objRestrictedListSettingsDTO = new RestrictedListSettingsDTO();

                using (var objCompanyDAL = new CompanyDAL())
                {
                    //get list for restricted list setting
                    lstCompanySettingConfigurationDTO = objCompanyDAL.GetCompanySettingConfigurationList(sConnectionString, Common.ConstEnum.Code.CompanyConfigType_RestrictedListSetting);

                    //set restricted list setting
                    foreach (CompanySettingConfigurationDTO configSettingDTO in lstCompanySettingConfigurationDTO)
                    {
                        switch (configSettingDTO.ConfigurationCodeId)
                        {
                        case Common.ConstEnum.Code.RestrictedListSetting_Preclearance_required:
                            objRestrictedListSettingsDTO.Preclearance_Required = Convert.ToInt32(configSettingDTO.ConfigurationValueCodeId);
                            break;

                        case Common.ConstEnum.Code.RestrictedListSetting_Preclearance_Approval:
                            objRestrictedListSettingsDTO.Preclearance_Approval = Convert.ToInt32(configSettingDTO.ConfigurationValueCodeId);
                            break;

                        case Common.ConstEnum.Code.RestrictedListSetting_Preclearance_Allow_Zero_Balance:
                            objRestrictedListSettingsDTO.Preclearance_AllowZeroBalance = Convert.ToInt32(configSettingDTO.ConfigurationValueCodeId);
                            break;

                        case Common.ConstEnum.Code.RestrictedListSetting_Preclearance_Form_F_Required:
                            objRestrictedListSettingsDTO.Preclearance_FORM_Required_Restricted_company = Convert.ToInt32(configSettingDTO.ConfigurationValueCodeId);
                            break;

                        case Common.ConstEnum.Code.RestrictedListSetting_Preclearance_Form_F_TemplateFile:
                            objRestrictedListSettingsDTO.Preclearance_Form_F_File_Id = Convert.ToInt32(configSettingDTO.ConfigurationValueOptional);
                            break;

                        case Common.ConstEnum.Code.RestrictedListSetting_Allow_Restricted_List_Search:
                            objRestrictedListSettingsDTO.Allow_Restricted_List_Search = Convert.ToInt32(configSettingDTO.ConfigurationValueCodeId);
                            objRestrictedListSettingsDTO.RLSearchLimit = configSettingDTO.RLSearchLimit;
                            break;
                        }
                    }
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }
            finally
            {
                lstCompanySettingConfigurationDTO = null;
            }
            return(objRestrictedListSettingsDTO);
        }
示例#23
0
        public IActionResult Review()
        {
            var        aesUserData = User.FindFirst(ClaimTypes.UserData).Value;
            var        UserData    = JsonConvert.DeserializeObject <B2dAccount>(AesCryptHelper.aesDecryptBase64(aesUserData, Website.Instance.AesCryptKey));
            var        xid         = UserData.COMPANY_XID;
            B2dCompany model       = CompanyDAL.GetCompany(xid);

            return(View(model));
        }
        public IEnumerable <CompanyMaster> Get()
        {
            CommonAPI commonApi = new CommonAPI();

            commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName);
            CompanyDAL companyDAL = new CompanyDAL(connectionString, userAccount, roleId, DBProviderName, companyCode);
            var        companies  = companyDAL.GetCompanies();

            return(companies);
        }
        public ReturnResult Post([FromBody] CompanyMaster objCompany)
        {
            CommonAPI commonApi = new CommonAPI();

            commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName);
            CompanyDAL   companyDAL   = new CompanyDAL(connectionString, userAccount, roleId, DBProviderName, companyCode);
            ReturnResult returnResult = companyDAL.SaveCompany(objCompany);

            return(returnResult);
        }
        public void InitCompaniesList(ObservableCollection <CompanyModel> CompaniesToWindow)
        {
            CompanyDAL          companyDAL = new CompanyDAL();
            List <CompanyModel> companies  = companyDAL.GetCompanies();

            foreach (var item in companies)
            {
                CompaniesToWindow.Add(item);
            }
        }
        public void CheckMemberByCardNumberTest()
        {
            int companyId = CompanyDAL.GetCompanies().Select(x => x.Id).Min();
            List <MemberModel> members    = MemberDAL.GetMembersOfCompany(companyId);
            string             cardnumber = members.First().CardNumber;
            DataBaseLayer      db         = new DataBaseLayer();

            Test1702.Model.MemberModel testmodel = db.CheckMemberByCardNumber(cardnumber);
            Assert.That(testmodel != null, Is.True);
        }
示例#28
0
 protected void gvCompany_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "DeleteCompany")
     {
         CompanyDAL compdal = new CompanyDAL();
         compdal.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
         compdal.DeleteCompany(e.CommandArgument.ToString());
         FillCompany();
     }
 }
示例#29
0
    private void SetAdditionalData()
    {
        if (CompanyID != 0)
        {
            CompanyDAL comp = new CompanyDAL();
            _CompanyInfo = comp.GetCompany(CompanyID);

            PropertyDAL prop = new PropertyDAL();
            _PropertyInfo = prop.GetProperties(CompanyID);
        }
    }
示例#30
0
        private void FillCompany(String Name)
        {
            CompanyDAL Compdal = new CompanyDAL();

            Compdal.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();

            List <Company> CompanyList = Compdal.GetCompany(Name);

            gvCompany.DataSource = CompanyList;
            gvCompany.DataBind();
        }