コード例 #1
0
 public void deleteSupplierEmployee(int employee)
 {
     SupplierMasterStoredProcedure objsupplieremployeedel = new SupplierMasterStoredProcedure();
     objsupplieremployeedel.deleteSupplierEmployee(employee);
 }
コード例 #2
0
 public void InsertCode(string SUPPLIER_COMPANY_NAME,string SUPPLIER_ID ,string Supplier)
 {
     SupplierMasterStoredProcedure objinsertcode = new SupplierMasterStoredProcedure();
     objinsertcode.InsertNewGenerateCode(SUPPLIER_COMPANY_NAME,SUPPLIER_ID,Supplier);
 }
コード例 #3
0
        public string InsertUpdateSupplierEmployeeNew(ArrayList Employee,string s)
        {

            CRM.DataAccess.AdministratorEntity.SupplierMasterStoredProcedure objinsertemployee = new CRM.DataAccess.AdministratorEntity.SupplierMasterStoredProcedure();
            Employee.Insert(10, Session["usersid"].ToString());
            //objinsertemployee.InsertUpdateSupplierEmployeeNew(Employee);

            System.Data.DataSet ds1 = objinsertemployee.CheckValidation();

            int j = 0;

            for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
            {

                if (ds1.Tables[0].Rows[i]["USER_NAME"].ToString().Equals(Employee[4]) || Employee[4].Equals(""))
                {
                    j = 1;
                    break;

                }

            }

            if (j == 0)
            {


                objinsertemployee.InsertUpdateSupplierEmployeeNew(Employee);
            }
            else if (j == 1)
            {

                
                System.Data.DataSet ds = objinsertemployee.InsertUpdateSupplierEmployeeNew(Employee);
                
                s = ds.Tables[0].Rows[0]["EMAIL_CHECKER"].ToString();
                if (s == "N")
                {

                }
                if (s == "Y")
                {

                }

            }
            else
            {

            }
            return s;
        }
コード例 #4
0
 public void InsertNewEmployee(string SUPPLIER_SR_NO)
 {
     SupplierMasterStoredProcedure objaddnewemployee = new SupplierMasterStoredProcedure();
     objaddnewemployee.InsertNewEmployee(SUPPLIER_SR_NO);
 }
コード例 #5
0
 public void InsertNewContect(string SUPPLIER_ID)
 {
     SupplierMasterStoredProcedure objaddnew = new SupplierMasterStoredProcedure();
     objaddnew.InsertNewContect(SUPPLIER_ID);
 }
コード例 #6
0
 public void deleteSupplierContect(int Contectid)
 {
     SupplierMasterStoredProcedure objsupplierdel = new SupplierMasterStoredProcedure();
     objsupplierdel.deleteSupplierContect(Contectid);
 }
コード例 #7
0
        public void InsertUpdateSupplierContect(ArrayList Contect)
        {

            SupplierMasterStoredProcedure objinsertcontect = new SupplierMasterStoredProcedure();
            Contect.Insert(19, Session["usersid"].ToString());
            objinsertcontect.InsertUpdateSupplierContect(Contect);

        }
コード例 #8
0
 public void deleteSupplier(int SUPPLIERID)
 {
     SupplierMasterStoredProcedure objsupplier = new SupplierMasterStoredProcedure();
     objsupplier.deleteSupplier(SUPPLIERID);
 }
コード例 #9
0
        public string InsertUpdateSupplier(ArrayList Supply,string s)
        {

            SupplierMasterStoredProcedure objsupplier = new SupplierMasterStoredProcedure();
            Supply.Insert(18, Session["usersid"].ToString());
            //objsupplier.InsertUpdateSupplier(Supply);

            System.Data.DataSet ds1 = objsupplier.CheckValidation();

            int j = 0;

            for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
            {

                if (ds1.Tables[0].Rows[i]["USER_NAME"].ToString().Equals(Supply[15]) || Supply[15].Equals(""))
                {
                    j = 1;
                    break;

                }

            }

            if (j == 0)
            {


                objsupplier.InsertUpdateSupplier(Supply);
            }
            else if (j == 1)
            {

               
                System.Data.DataSet ds = objsupplier.InsertUpdateSupplier(Supply);

                s = ds.Tables[0].Rows[0]["EMAIL_CHECKER"].ToString();
                if (s == "N")
                {

                }
                if (s == "Y")
                {

                }

            }
            else
            {

            }
            return s;

        }