protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
Int16 Emp_ID = Convert.ToInt16(args.Value);
bool DoesntExistsInDatabase = false;
using (var db = new MGO_Entities())
{
DoesntExistsInDatabase = (from Employee in db.Employees
where Employee.Emp_ID == Emp_ID
select Employee).IsNull();
}
args.IsValid = DoesntExistsInDatabase;
}
protected void CustomValidator3_ServerValidate(object source, ServerValidateEventArgs args)
{
Int16 Cat_Num = Convert.ToInt16(args.Value);
bool DoesntExistsInDatabase = false;
using (var db = new MGO_Entities())
{
DoesntExistsInDatabase = (from category in db.Categories
where category.Cat_Num == Cat_Num
select category).IsNull();
}
args.IsValid = DoesntExistsInDatabase;
}
protected void CustomValidator2_ServerValidate(object source, ServerValidateEventArgs args)
{
string Cat_Description = args.Value;
bool DoesntExistsInDatabase = false;
using (var db = new MGO_Entities())
{
DoesntExistsInDatabase = (from category in db.Categories
where category.Cat_Description == Cat_Description
select category).IsNull();
}
args.IsValid = DoesntExistsInDatabase;
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
Int16 Cust_ID = Convert.ToInt16(args.Value);
bool DoesntExistsInDatabase = false;
using (var db = new MGO_Entities())
{
DoesntExistsInDatabase = (from Customer in db.Customers
where Customer.Cust_ID == Cust_ID
select Customer).IsNull();
}
args.IsValid = DoesntExistsInDatabase;
}
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
{
Int16 SKU = Convert.ToInt16(args.Value);
bool DoesntExistsInDatabase = false;
using (var db = new MGO_Entities())
{
DoesntExistsInDatabase = (from item in db.Items
where item.SKU == SKU
select item).IsNull();
}
args.IsValid = DoesntExistsInDatabase;
DisplayForm();
}
protected void getCat_Descript(object sender, string id, View view = View.Form, FormView formView = null)
{
//SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MGOConnectionString"].ConnectionString);
//connection.Open();
//string query = $@"Select [Cat_Description]
// FROM CATEGORY
// WHERE Cat_Num = {Convert.ToInt16((sender as DropDownList).SelectedValue)}";
//SqlCommand selectCommand = new SqlCommand(query, connection);
//SqlDataReader sqlData = selectCommand.ExecuteReader();
//string Cat_Descript = "";
//while (sqlData.Read())
//{
// Cat_Descript = (string)sqlData["Cat_Description"];
//}
//sqlData.Close();
//connection.Close();
string Cat_Descript;
short Cat_Num = Convert.ToInt16((sender as DropDownList).SelectedValue);
using (var db = new MGO_Entities())
{
Cat_Descript = (from category in db.Categories
where category.Cat_Num == Cat_Num
select category.Cat_Description).SingleOrDefault();
}
if (view == View.Form)
{
if (formView.CurrentMode == FormViewMode.Insert)
{
(formView.FindControl(id) as Label).Text = Cat_Descript;
}
else if (formView.CurrentMode == FormViewMode.Edit)
{
(formView.FindControl(id) as TextBox).Text = Cat_Descript;
}
}
else
{
(grdviewProducts.Rows[grdviewProducts.EditIndex].FindControl(id) as Label).Text = Cat_Descript;
}
}
