public string ClusterDelete(cluster_prop clusterprop) { try { return(SqlHelper.ExecuteDataset(com.con, "usp_Cluster_Delete", new object[] { clusterprop.ClusterID }).Tables[0].Rows[0][0].ToString()); } catch (Exception e) { throw e; } }
public string ClusterUpdate(cluster_prop clusterprop) { try { return(SqlHelper.ExecuteDataset(com.con, "usp_ClusterMaster_Update", new object[] { clusterprop.ClusterName, clusterprop.Address, clusterprop.StateID, clusterprop.ImpAgencyID, clusterprop.TechAgencyID }).Tables[0].Rows[0][0].ToString()); } catch (Exception e) { throw e; } }
public DataTable ClusterSearch(cluster_prop clusterprop) { try { return(SqlHelper.ExecuteDataset(com.con, "usp_Cluster_Search", new object[] { clusterprop.ClusterName }).Tables[0]); } catch (Exception e) { throw e; } }
public string ClusterDelete(cluster_prop clusterprop) { try { clusterdal = new cluster_dal(); string strMsg = clusterdal.ClusterDelete(clusterprop); return(strMsg); } catch (Exception e) { ErrMessage = e.Message; return(""); } }
public DataTable ClusterSearch(cluster_prop clusterprop) { try { clusterdal = new cluster_dal(); DataTable dt = clusterdal.ClusterSearch(clusterprop); return(dt); } catch (Exception e) { ErrMessage = e.Message; return(null); } }
public string ClusterCheckIfExist(cluster_prop clusterprop) { try { DataSet ds = SqlHelper.ExecuteDataset(com.con, "usp_Cluster_CheckIfExist", new object[] { clusterprop.ClusterName }); if (ds.Tables.Count > 1) { return(ds.Tables[1].Rows[0][0].ToString()); } else { return(ds.Tables[0].Rows[0][0].ToString()); } } catch (Exception e) { throw e; } }