public SupplyModelss GetByName(string Name)
{
try
{
var query = "SELECT * FROM tbl_Supply WHERE Name='" + Name + "'";
var reader = _pharmaDb.ExecuteReader(query, _connectionString);
if (reader.HasRows)
{
reader.Read();
var SupplyModel = new SupplyModelss()
{
Name = reader["Name"].ToString(),
Email = reader["Email"].ToString(),
Phone = reader["Phone"].ToString(),
Address = reader["Address"].ToString(),
Notes = reader["Notes"].ToString()
};
return(SupplyModel);
}
return(null);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool Save(SupplyModelss s)
{
try
{
var query = "INSERT INTO tbl_Supply (Name,Email,Phone,Address, Notes) VALUES('" + s.Name + "','" + s.Email + "','" + s.Phone + "','" + s.Address + "','" + s.Notes + "')";
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 (txtName.Text == "" || txtEmail.Text == "" || txtPhone.Text == "" || txtAddress.Text == "" || txtNotrs.Text == "")
{
string validationMessage = "Please fillup Required fields";
lblMessage.Text = validationMessage;
return;
}
var IsUserNameExist = _supplyManager.IsUserNameExist(txtName.Text);
if (IsUserNameExist)
{
var validationMessage = "Shalf Already Exist";
lblMessage.Text = validationMessage;
return;
}
var SupplyModel = new SupplyModelss();
SupplyModel.Name = txtName.Text;
SupplyModel.Email = txtEmail.Text;
SupplyModel.Phone = txtPhone.Text;
SupplyModel.Address = txtAddress.Text;
SupplyModel.Notes = txtNotrs.Text;
var isSave = _supplyManager.Save(SupplyModel);
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 List <SupplyModelss> GetAllSupplliers()
{
var _SuppliersList = new List <SupplyModelss>();
string query = ("Select *From Suppliers");
var reader = _pharmaDb.Reader(query, _pharmaDb.ConnectionStrings());
if (reader.HasRows)
{
while (reader.Read())
{
var _Suppliers = new SupplyModelss();
_Suppliers.Id = Convert.ToInt32(reader["Id"].ToString());
_Suppliers.Name = reader["Name"].ToString();
_SuppliersList.Add(_Suppliers);
}
}
reader.Close();
return(_SuppliersList);
}
public bool Save(SupplyModelss shalf)
{
var save = _supplyRepository.Save(shalf);
return(save);
}
