コード例 #1
0
        private void btnSave_Click(object sender, System.EventArgs e)
        {
            //Adding to Contact Table
            if(chkNoDept.Checked==false)
            {
                if(txtCompName.Text=="")
                {
                    tbcDepartment.SelectedIndex=0;
                    Scheduler.BusinessLayer.Message.MsgInformation("Enter Department Name");
                    txtCompName.Focus();
                    return;
                }
            }

            if(cmbClient.Text=="")
            {
                tbcDepartment.SelectedIndex=0;
                BusinessLayer.Message.MsgInformation("Enter Client");
                cmbClient.Focus();
                return;
            }

            bool boolSuccess;
            Scheduler.BusinessLayer.Contact objContact=null;

            objContact=new Scheduler.BusinessLayer.Contact();
            objContact.ContactID=0;

            objContact.LastName = "";
            objContact.LastNamePhonetic="";
            objContact.LastNameRomaji="";
            objContact.FirstName="";
            objContact.FirstNamePhonetic="";
            objContact.FirstNameRomaji="";
            //if(chkNoDept.Checked)
            //	objContact.CompanyName="No Department";
            //else
            objContact.NickName=txtNickName.Text;
            objContact.CompanyName=txtCompName.Text;
            objContact.CompanyNamePhonetic=txtCompPhonetic.Text;
            objContact.CompanyNameRomaji=txtCompRomaji.Text;
            objContact.TitleForName="";
            objContact.TitleForJob="";
            objContact.Street1=txtStreet1.Text;
            objContact.Street2=txtStreet2.Text;
            objContact.Street3=txtStreet3.Text;
            objContact.City=txtCity.Text;
            objContact.State=txtState.Text;
            objContact.PostalCode=txtPost.Text;
            objContact.Country=txtCountry.Text;
            objContact.ContactType=3;
            objContact.BlockCode=cmbBlock.Text;
            objContact.Email1="";
            objContact.Email2="";
            objContact.AccountRepLastName=txtAccLName.Text;
            objContact.AccountRepLastNamePhonetic=txtAccLPhonetic.Text;
            objContact.AccountRepLastNameRomaji=txtAccLRomaji1.Text;
            objContact.AccountRepFirstName=txtAccFirstName.Text;
            objContact.AccountRepFirstNamePhonetic=txtAccFirstPhonetic.Text;
            objContact.AccountRepFirstNameRomaji=txtAccFirstRomaji.Text;
            objContact.Phone1=txtPhone1.Text;
            objContact.Phone2=txtPhone2.Text;
            objContact.PhoneMobile1="";
            objContact.PhoneMobile2="";
            objContact.PhoneBusiness1="";
            objContact.PhoneBusiness2="";
            objContact.PhoneFax1=txtFax1.Text;
            objContact.PhoneFax2=txtFax2.Text;
            objContact.PhoneOther=txtPhoneOther.Text;
            objContact.Url=txtUrl.Text;

            objContact.DateBirth=Convert.ToDateTime(null);
            objContact.DateJoined=Convert.ToDateTime(null);
            objContact.DateEnded=Convert.ToDateTime(null);

            //objContact.TimeStatus=.Text;
            objContact.Nationality="";
            objContact.Married=0;
            objContact.NumberDependents=0;

            objContact.VisaStatus="";
            objContact.VisaFromDate=Convert.ToDateTime(null);
            objContact.VisaUntilDate=Convert.ToDateTime(null);

            objContact.ClosestStation1=txtClosestSt1.Text;
            objContact.ClosestLine1=txtClosestLine1.Text;
            Int16 minToStation = 0;
            if (txtMintSt1.Text != "")
            {
                Int16.TryParse(txtMintSt1.Text, out minToStation);
            }
            Int16 minToStation2 = 0;
            if (txtMintSt2.Text != "")
            {
                Int16.TryParse(txtMintSt2.Text, out minToStation2);
            }
            objContact.MinutesToStation1=minToStation;
            objContact.MinutesToStation2 = minToStation2;
            objContact.ClosestStation2=txtClosestSt2.Text;
            objContact.ClosestLine2=txtClosestLine2.Text;

            objContact.ContactStatus=cmbStatus.SelectedIndex;

            int intCID=0;
            intCID = Common.GetCompanyID(
                "Select ContactID From Contact " +
                "Where (CompanyName =@CompanyName OR NickName=@CompanyName) ", cmbClient.Text
                );

            if ((_mode == "Add") || (_mode == "AddClone") || (_mode == ""))
            {
                if(objContact.Exists(txtCompName.Text, intCID, 3))
                {
                    Scheduler.BusinessLayer.Message.MsgInformation("Duplicate Department Name not allowed");
                    txtCompName.Focus();
                    return;
                }
                if(txtNickName.Text!="")
                {
                    if(objContact.NickNameExists(txtNickName.Text, intCID, 3))
                    {
                        Scheduler.BusinessLayer.Message.MsgInformation("Duplicate Abbreviated Name not allowed");
                        txtNickName.Focus();
                        return;
                    }
                }
                boolSuccess = objContact.InsertData();
            }
            else
            {
                if((txtCompName.Tag.ToString()!=txtCompName.Text) || (cmbClient.Tag.ToString()!=cmbClient.Text))
                {
                    if(objContact.Exists(txtCompName.Text, intCID, 3))
                    {
                        Scheduler.BusinessLayer.Message.MsgInformation("Duplicate Department Name not allowed");
                        txtCompName.Focus();
                        return;
                    }
                }
                if(txtNickName.Text!="")
                {
                    if((txtNickName.Tag.ToString()!=txtNickName.Text) || (cmbClient.Tag.ToString()!=cmbClient.Text))
                    {
                        if(objContact.NickNameExists(txtNickName.Text, intCID, 3))
                        {
                            Scheduler.BusinessLayer.Message.MsgInformation("Duplicate Abbreviated Name not allowed");
                            txtNickName.Focus();
                            return;
                        }
                    }
                }
                objContact.ContactID=_contactid;
                boolSuccess = objContact.UpdateData();
            }
            if(!boolSuccess)
            {
                if (_mode == "Add")
                    Scheduler.BusinessLayer.Message.ShowException("Adding Contact record.", objContact.Message);
                else if (_mode == "AddClone")
                    Scheduler.BusinessLayer.Message.ShowException("Cloning Contact record.", objContact.Message);
                else
                    Scheduler.BusinessLayer.Message.ShowException("Updating Contact record.", objContact.Message);
                return;
            }

            //Getting ContactID
            _contactid = objContact.ContactID;

            //Adding to Department Table

            /*if(txtDeptName.Text=="")
            {
                BusinessLayer.Message.MsgInformation("Enter Department");
                txtDeptName.Focus();
                return;
            }
            if(cmbContact.Text=="")
            {
                BusinessLayer.Message.MsgInformation("Enter Contact");
                cmbContact.Focus();
                return;
            }
            if(cmbClient.Text=="")
            {
                BusinessLayer.Message.MsgInformation("Enter Client");
                cmbClient.Focus();
                return;
            }*/

            Department objDept=new Department();
            //objDept.DeptName = txtDeptName.Text;

            if(cmbClient.Text.Trim()=="")
            {
                objDept.ClientID=0;
            }
            else
            {
                objDept.ClientID = Common.GetCompanyID(
                    "Select ContactID From Contact " +
                    "Where (CompanyName =@CompanyName OR NickName=@CompanyName) ", cmbClient.Text
                    );
            }

            /*if(cmbContact.Text.Trim()=="")
            {
                objDept.ContactID=0;
            }
            else
            {
                string[] arr = cmbContact.Text.Split(new char[]{','});
                if(arr.Length==1)
                {
                    objDept.ContactID = Common.GetID(
                        "Select ContactID From Contact " +
                        "Where LastName ='" + arr[0].Trim() + "' "
                        );
                }
                else
                {
                    objDept.ContactID = Common.GetID(
                        "Select ContactID From Contact " +
                        "Where LastName ='" + arr[0].Trim() + "' and FirstName = '" + arr[1].Trim() + "' "
                        );
                }
            }*/

            objDept.ContactID = _contactid;
            objDept.StatusID = cmbStatus.SelectedIndex;

            if ((_mode == "Add") || (_mode == "AddClone") || (_mode == ""))
            {
                if(objDept.InsertData()==false)
                {
                    BusinessLayer.Message.ShowException("Adding Department", objDept.Message);
                }
                else
                {
                    if(intRandomNo>0)
                    {
                        //replace the randomno with deptid
                        objContact.RefID=objDept.DeptID;
                        objContact.UpdateRefID(intRandomNo);
                    }
                }
            }
            else
            {
                objDept.DeptID=_deptid;
                if(objDept.UpdateData()==false)
                {
                    BusinessLayer.Message.ShowException("Editing Department", objDept.Message);
                }
            }

            this.DialogResult = DialogResult.OK;
            Close();
        }