public bool Save(ShalfModel shalf)
{
try
{
var query = "INSERT INTO tbl_Shelf (Name, NumericNumber) VALUES('" + shalf.Name + "','" + shalf.NumericNumber + "')";
var rowAffected = _pharmaDb.ExecuteNonQuery(query, _connectionString);
return(rowAffected > 0);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtShalfName.Text == "" || txtShalfNumber.Text == "")
{
string validationMessage = "Please fillup Required fields";
lblMessage.Text = validationMessage;
return;
}
var IsUserNameExist = _shalfManager.IsUserNameExist(txtShalfName.Text);
if (IsUserNameExist)
{
var validationMessage = "Shalf Already Exist";
lblMessage.Text = validationMessage;
return;
}
var IsNumberExist = _shalfManager.IsNumberExist(txtShalfNumber.Text);
if (IsNumberExist)
{
var validationMessage = "Shalf Number Already Exist";
lblMessage.Text = validationMessage;
return;
}
var ShalfModel = new ShalfModel();
ShalfModel.Name = txtShalfName.Text;
ShalfModel.NumericNumber = txtShalfNumber.Text;
var isSave = _shalfManager.Save(ShalfModel);
if (isSave)
{
RefreshField();
string successMessage = " Saved Successfully";
lblMessage.Text = successMessage;
lblMessage.ForeColor = Color.Green;
return;
}
string failMessage = "Fild Not Saved ";
lblMessage.Text = failMessage;
}
catch (Exception exception)
{
lblMessage.Text = exception.Message;
}
}
public ShalfModel GetByNumber(string Number)
{
try
{
var query = "SELECT * FROM tbl_Shelf WHERE NumericNumber='" + Number + "'";
var reader = _pharmaDb.ExecuteReader(query, _connectionString);
if (reader.HasRows)
{
reader.Read();
var ShalfModel = new ShalfModel()
{
Name = reader["Name"].ToString(),
NumericNumber = reader["NumericNumber"].ToString(),
};
return(ShalfModel);
}
return(null);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool Save(ShalfModel shalf)
{
var save = _shalfRepository.Save(shalf);
return(save);
}
