public static DataTable CheckGSTExculisveOrInclusive(String companyId) { CreateConnectionString objcon = new CreateConnectionString(); DataTable dt = new DataTable(); String companyDbString = GetCompanyDbString(companyId, "Accounts"); if (!string.IsNullOrEmpty(companyDbString)) { using (SqlConnection con = new SqlConnection(companyDbString)) { try { using (SqlCommand cmd = new SqlCommand("uspCheckGSTExculisveOrInclusiveSQMS", con)) { using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { con.Open(); cmd.CommandType = CommandType.StoredProcedure; sda.Fill(dt); } } } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } } return(dt); }
public SQLExecution(string companyID, string moduleName) { MessageHeader = "SqlExecution"; objConnectionString = new CreateConnectionString(); ConnectionString = objConnectionString.GetCompanyDbString(companyID, moduleName); }