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;
}
}
