public int UpdateDeployment(Deployement p_Deployement)
{
MySqlParameter[] parameters = new MySqlParameter[] {
new MySqlParameter("p_DeploymentId", p_Deployement.DeploymentId),
new MySqlParameter("p_DeploymentName", p_Deployement.DeploymentName),
new MySqlParameter("p_DeploymentType", p_Deployement.DeploymentType),
new MySqlParameter("p_Description", p_Deployement.Description),
new MySqlParameter("p_ClientName", p_Deployement.ClientName),
new MySqlParameter("p_Address", p_Deployement.Address)
};
return(MySQLDB.MySQLDBHelper.ExecuteNonQuery("UpdateDeployment", CommandType.StoredProcedure, parameters));
}
//AddDeployement
/// <summary>
///
/// </summary>
/// <param name="p_Deployement"></param>
/// <returns></returns>
public int InsertDeployment(Deployement p_Deployement)
{
//if (!IsDeploymentExists(p_Deployement.Description))
//{
int result = 0;
MySqlParameter[] parameters = new MySqlParameter[] {
new MySqlParameter("p_DeploymentName", p_Deployement.DeploymentName),
new MySqlParameter("p_Description", p_Deployement.Description),
new MySqlParameter("p_DeploymentType", p_Deployement.DeploymentType),
new MySqlParameter("p_ClientName", p_Deployement.ClientName),
new MySqlParameter("p_Address", p_Deployement.Address),
new MySqlParameter("p_result", MySqlDbType.Int32, 2, ParameterDirection.Output, false, 1, 1, "Out", DataRowVersion.Default, result)
};
return(MySQLDB.MySQLDBHelper.ExecuteNonQuery("AddDeployment", CommandType.StoredProcedure, parameters));
//if (result == 1) return true;
//else return false;
//}
//else return false;
}
public int ModifyDeployment(Deployement p_Deployement)
{
return(objDeployment.UpdateDeployment(p_Deployement));
}
public int AddDeployment(Deployement p_Deployement)
{
return(objDeployment.InsertDeployment(p_Deployement));
}
