public int Update(string id, string name)
{
if (string.IsNullOrEmpty(id))
{
SetError(98, "Industry id is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(name))
{
SetError(98, "Industry name is null or empty");
return(Error_Number);
}
Industry_Info obj = base.GetIndustryByID(id);
if (obj == null)
{
SetError(99, "Industry not find");
return(Error_Number);
}
obj.Name = name;
if (base.Update(obj) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, Error_Message);
}
return(Error_Number);
}
private static bool Validation(Industry_Info obj)
{
bstr = new StringBuilder("");
if (obj == null)
{
bstr.Append("Invalid object\n");
}
if (string.IsNullOrEmpty(obj.ID))
{
bstr.Append("ID is null or empty\n");
}
if (string.IsNullOrEmpty(obj.Name))
{
bstr.Append("Name is null or empty\n");
}
if (string.IsNullOrEmpty(bstr.ToString()))
{
return(true);
}
else
{
return(false);
}
}
public int Insert(string id, string name)
{
if (string.IsNullOrEmpty(id))
{
SetError(98, "Industry id is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(name))
{
SetError(98, "Industry name is null or empty");
return(Error_Number);
}
Industry_Info obj = new Industry_Info();
obj.ID = id;
obj.Name = name;
if (base.Insert(obj) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, Error_Message);
}
return(Error_Number);
}
public SqlCommand EditOneIndustry(Industry_Info objIndustryInfo)
{
SqlCommand command = new SqlCommand("Update Industry Set Name= @Name Where ID= @ID");
command.CommandType = CommandType.Text;
command.Parameters.Add("@ID", SqlDbType.NVarChar, 5).Value = objIndustryInfo.ID;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 135).Value = objIndustryInfo.Name;
this.AddCommand(command);
return(command);
}
public SqlCommand CreateOneIndustry(Industry_Info objIndustryInfo)
{
SqlCommand command = new SqlCommand("insert into Industry (ID, Name) Values (@ID, @Name)");
command.CommandType = CommandType.Text;
command.Parameters.Add("@ID", SqlDbType.NVarChar, 5).Value = objIndustryInfo.ID;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 135).Value = objIndustryInfo.Name;
this.AddCommand(command);
return(command);
}
public static int Update(Industry_Info obj)
{
if (Validation(obj))
{
return(dalIn.Update(obj.ID, obj.Name));
}
else
{
throw new Exception(dalIn.Error_Message);
}
}
protected int Delete(Industry_Info obj)
{
if (obj == null)
{
throw new Exception("Invalid data input");
}
_dalIn.RemoveOneIndustry(obj.ID);
if (_dalIn.Execute())
{
return(_dalIn.LastRecordsEffected);
}
else
{
throw _dalIn.GetException;
}
}
private Industry_Info GenerateObj(DataRow row)
{
if (row == null)
{
throw new Exception("Invalid Datarow");
}
Industry_Info inInfo = new Industry_Info();
if (row["ID"] != DBNull.Value)
{
inInfo.ID = Convert.ToString(row["ID"]);
}
if (row["Name"] != DBNull.Value)
{
inInfo.Name = Convert.ToString(row["Name"]);
}
return(inInfo);
}
public int Delete(string id)
{
if (string.IsNullOrEmpty(id))
{
SetError(98, "Industry id is null or empty");
return(Error_Number);
}
Industry_Info obj = base.GetIndustryByID(id);
if (obj == null)
{
SetError(99, "Industry not find");
return(Error_Number);
}
if (base.Delete(obj) != 0)
{
SetError(0, string.Empty);
}
else
{
SetError(99, Error_Message);
}
return(Error_Number);
}
