//Check Error
public bool IsError(Companny companny)
{
if (!(string.IsNullOrEmpty(companny.ErrorText)))
{
return(true);
}
return(false);
}
//Verified Field
public bool IsVerified(Companny companny)
{
if (string.IsNullOrEmpty(companny.Name))
{
return(true);
}
return(false);
}
//Update Category
public bool IsUpdate(Companny companny)
{
SqlConnection conn = new SqlConnection(connection.connectionDb);
string updateQuery = @"UPDATE Company SET Name = '" + companny.Name + "' Where Id = (SELECT Id FROM Company Where Name = '" + companny.OldName + "')";
SqlCommand updateCommand = new SqlCommand(updateQuery, conn);
conn.Open();
bool isRowAffected = updateCommand.ExecuteNonQuery() > 0;
conn.Close();
return(isRowAffected);
}
//Save Companny
public bool IsAdd(Companny companny)
{
SqlConnection conn = new SqlConnection(connection.connectionDb);
string insertQuery = @"INSERT INTO Company VALUES('" + companny.Name + "')";
SqlCommand insertCommand = new SqlCommand(insertQuery, conn);
conn.Open();
bool isRowAffected = insertCommand.ExecuteNonQuery() > 0;
conn.Close();
return(isRowAffected);
}
//Check Existing Item
public bool IsExist(Companny companny)
{
SqlConnection conn = new SqlConnection(connection.connectionDb);
string query = @"SELECT * FROM Company WHERE Name = '" + companny.Name + "' ";
SqlCommand command = new SqlCommand(query, conn);
conn.Open();
SqlDataReader dr = command.ExecuteReader();
bool dataExisted = dr.Read();
conn.Close();
return(dataExisted);
}
//Check Exist Data
public bool IsExisted(Companny companny)
{
bool add = companyRepository.IsExist(companny);
return(add);
}
//Update Companny
public bool IsUpdated(Companny companny)
{
bool add = companyRepository.IsUpdate(companny);
return(add);
}
//Save Companny
public bool IsAdded(Companny companny)
{
bool add = companyRepository.IsAdd(companny);
return(add);
}
