示例#1
0
        public bool AddCompany(CompanyBE company)
        {
            SqlConnection con = commonDAL.Connection();
            SqlCommand cmd = new SqlCommand("Sp_SYS_InsertCompanyDetails", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@CompanyName", SqlDbType.VarChar).Value = company.CompanyName;
            cmd.Parameters.Add("@ContactPerson1Name", SqlDbType.VarChar).Value = company.ContactPerson1Name;
            cmd.Parameters.Add("@ContactPerson1Address", SqlDbType.VarChar).Value = company.ContactPerson1Address;
            cmd.Parameters.Add("@ContactPerson1MobileNo", SqlDbType.VarChar).Value = company.ContactPerson1MobileNo;
            cmd.Parameters.Add("@ContactPerson1EmailId", SqlDbType.VarChar).Value = company.ContactPerson1EmailId;
            cmd.Parameters.Add("@ContactPerson2Name", SqlDbType.VarChar).Value = company.ContactPerson2Name;
            cmd.Parameters.Add("@ContactPerson2Address", SqlDbType.VarChar).Value = company.ContactPerson2Address;
            cmd.Parameters.Add("@ContactPerson2MobileNo", SqlDbType.VarChar).Value = company.ContactPerson2MobileNo;
            cmd.Parameters.Add("@ContactPerson2EmailId", SqlDbType.VarChar).Value = company.ContactPerson2EmailId;
            cmd.Parameters.Add("@LogoPath", SqlDbType.VarChar).Value = company.LogoPath;
            cmd.Parameters.Add("@LogoName", SqlDbType.VarChar).Value = company.LogoName;
            cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = company.UserName;
            cmd.Parameters.Add("@EncPass", SqlDbType.VarChar).Value = company.Password;
            cmd.Parameters.Add("@UMDBName", SqlDbType.VarChar).Value = company.CMUMDBName;
            cmd.Parameters.Add("@DMSDBName", SqlDbType.VarChar).Value = company.CMDMSDBName;
            cmd.Parameters.Add("@DBFilesize", SqlDbType.VarChar).Value = company.DBFileSize;
            //con.Open();
            int count = cmd.ExecuteNonQuery();
            con.Close();
            if (count == 1)
            {
                return true;
            }
            else
            {
                return false;
            }

        }
示例#2
0
 public bool ActivateCompany(CompanyBE company)
 {
     CompanyDAL companyDAL = new CompanyDAL();
     if (companyDAL.ActivateCompany(company))
     {
         return true;
     }
     else
     {
         return false;
     }
 }
示例#3
0
 public bool GetDetailsbyId(CompanyBE company, ref DataTable dt)
 {
     CompanyDAL companyDAL = new CompanyDAL();
     if (companyDAL.GetDetailsbyId(company, ref dt))
     {
         return true;
     }
     else
     {
         return false;
     }
 }
示例#4
0
 public bool ModifyCompanyRecords(CompanyBE company)
 {
     CompanyDAL companyDAL = new CompanyDAL();
     if (companyDAL.ModifyCompanyRecords(company))
     {
         return true;
     }
     else
     {
         return false;
     }
 }
示例#5
0
        public bool ActivateCompany(CompanyBE company)
        {
            int ReturnOutput = 0;
            SqlConnection con = commonDAL.Connection();

            SqlCommand cmd1 = new SqlCommand("SP_SA_RestoreModelDb", con);
            cmd1.CommandType = CommandType.StoredProcedure;

            cmd1.Parameters.Add("@DestDBName", SqlDbType.VarChar).Value = company.CMDMSDBName;
            cmd1.Parameters.Add("@ReturnCode", SqlDbType.Int);
            cmd1.Parameters["@ReturnCode"].Direction = ParameterDirection.Output;

            //con.Open();
            int count1 = cmd1.ExecuteNonQuery();
            ReturnOutput = Convert.ToInt32(cmd1.Parameters["@ReturnCode"].Value);
            con.Close();

            if (ReturnOutput == 1)
            {

                SqlCommand cmd = new SqlCommand("Sp_SYS_ActivateCompany", con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = company.CompanyId;

                con.Open();

                int count = cmd.ExecuteNonQuery();

                con.Close();

                if (count > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return false;
            }
        }
示例#6
0
        public bool ModifyCompanyRecords(CompanyBE company)
        {
            SqlConnection con = commonDAL.Connection();
            SqlCommand cmd = new SqlCommand("Sp_SYS_ModifyCompanyRecordsbyId", con);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@CompanyId", SqlDbType.VarChar).Value = company.CompanyId;
            cmd.Parameters.Add("@CompanyName", SqlDbType.VarChar).Value = company.CompanyName;
            cmd.Parameters.Add("@ContactPerson1Name", SqlDbType.VarChar).Value = company.ContactPerson1Name;
            cmd.Parameters.Add("@ContactPerson1Address", SqlDbType.VarChar).Value = company.ContactPerson1Address;
            cmd.Parameters.Add("@ContactPerson1MobileNo", SqlDbType.VarChar).Value = company.ContactPerson1MobileNo;
            cmd.Parameters.Add("@ContactPerson1EmailId", SqlDbType.VarChar).Value = company.ContactPerson1EmailId;
            cmd.Parameters.Add("@ContactPerson2Name", SqlDbType.VarChar).Value = company.ContactPerson2Name;
            cmd.Parameters.Add("@ContactPerson2Address", SqlDbType.VarChar).Value = company.ContactPerson2Address;
            cmd.Parameters.Add("@ContactPerson2MobileNo", SqlDbType.VarChar).Value = company.ContactPerson2MobileNo;
            cmd.Parameters.Add("@ContactPerson2EmailId", SqlDbType.VarChar).Value = company.ContactPerson2EmailId;
            cmd.Parameters.Add("@LogoName", SqlDbType.VarChar).Value = company.LogoName;
            cmd.Parameters.Add("@LogoPath", SqlDbType.VarChar).Value = company.LogoPath;
            cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = company.UserName;
            cmd.Parameters.Add("@EncPass", SqlDbType.VarChar).Value = company.Password;

            //con.Open();

            int count = cmd.ExecuteNonQuery();

            con.Close();

            if (count == 2)
            {
                return true;
            }
            else
            {
                return false;
            }

        }
示例#7
0
        public bool GetDetailsbyId(CompanyBE company, ref DataTable dt)
        {
            SqlConnection con = commonDAL.Connection();
            SqlDataAdapter da = new SqlDataAdapter("Sp_SYS_GetDetailsbyId", con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;

            da.SelectCommand.Parameters.Add("@CompanyId", SqlDbType.Int).Value = company.CompanyId;

            da.Fill(dt);


            if (dt.Rows.Count == 1)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
示例#8
0
        public bool DeleteCompany(CompanyBE company)
        {
            SqlConnection con = commonDAL.Connection();
            SqlCommand cmd = new SqlCommand("Sp_SYS_DeleteCompany", con);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = company.CompanyId;

            //con.Open();

            int count = cmd.ExecuteNonQuery();

            con.Close();

            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }