public static string Insert(Customer_Info _Customer)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_insertCustomer_Info";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Code";
param.Value = _Customer.Code;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Name";
param.Value = _Customer.Name;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Address";
param.Value = _Customer.Address;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Zip_Postal";
param.Value = _Customer.Zip_Postal;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@State_Province";
param.Value = _Customer.State_Province;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Phone";
param.Value = _Customer.Phone;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@City";
param.Value = _Customer.City;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Country";
param.Value = _Customer.Country;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Fax";
param.Value = _Customer.Fax;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CreatedBy";
param.Value = _Customer.CreatedBy;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
return Return;
}
public Customer_Info Get_Customer_Info_By_Id(int ID)
{
Customer_Info _Customer_Info = new Customer_Info();
DataTable dt = Customer_Info_DA.Get_Customer_Info_By_Id(ID);
foreach (DataRow row in dt.Rows)
{
_Customer_Info.ID = ID;
_Customer_Info.Code = row["Code"].ToString();
_Customer_Info.Name = row["Name"].ToString();
_Customer_Info.Address = row["Address"].ToString();
_Customer_Info.Zip_Postal = row["Zip/Postal"].ToString();
_Customer_Info.State_Province = row["State/Province"].ToString();
_Customer_Info.Phone = row["Phone"].ToString();
_Customer_Info.City = row["City"].ToString();
_Customer_Info.Country = row["Country"].ToString();
_Customer_Info.Fax = row["Fax"].ToString();
}
return _Customer_Info;
}
public string Insert(string Code, string Name, string Address, string Zip_Postal,
string State_Province, string Phone, string City, string Country, string Fax)
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.Code = Code;
_Customer_Info.Name = Name;
_Customer_Info.Address = Address;
_Customer_Info.Zip_Postal = Zip_Postal;
_Customer_Info.State_Province = State_Province;
_Customer_Info.Phone = Phone;
_Customer_Info.City = City;
_Customer_Info.Country = Country;
_Customer_Info.Fax = Fax;
_Customer_Info.CreatedBy = Session["User"].ToString();
return Customer_Info_DA.Insert(_Customer_Info);
}
public string Update(int ID, string Code, string Name, string Address, string Zip_Postal,
string State_Province, string Phone, string City, string Country, string Fax)
{
Customer_Info _Customer_Info = new Customer_Info();
_Customer_Info.ID = ID;
_Customer_Info.Code = Code;
_Customer_Info.Name = Name;
_Customer_Info.Address = Address;
_Customer_Info.Zip_Postal = Zip_Postal;
_Customer_Info.State_Province = State_Province;
_Customer_Info.Phone = Phone;
_Customer_Info.City = City;
_Customer_Info.Country = Country;
_Customer_Info.Fax = Fax;
_Customer_Info.UpdatedBy = Session["User"].ToString();
if (_Customer_Info.UpdatedBy.ToString().ToUpper() == ("Mr. Asif").ToString().ToUpper() || _Customer_Info.UpdatedBy.ToString().ToUpper() == ("Saud Piracha").ToString().ToUpper())
{
return Customer_Info_DA.Update(_Customer_Info);
}
else
{
return "-1";
}
}
public Customer_Info GetCustomerInfoByCustomerId(int CustomerId)
{
// Customer Detail
Customer_Info _Customer_Info = new Customer_Info();
DataTable dt = Customer_Info_DA.Get_Customer_Info_By_Id(CustomerId);
_Customer_Info.Name = dt.Rows[0]["Name"].ToString();
_Customer_Info.Address = dt.Rows[0]["Address"].ToString();
_Customer_Info.Zip_Postal = dt.Rows[0]["Zip/Postal"].ToString();
_Customer_Info.State_Province = dt.Rows[0]["State/Province"].ToString();
_Customer_Info.City = dt.Rows[0]["City"].ToString();
_Customer_Info.Country = dt.Rows[0]["Country"].ToString();
return _Customer_Info;
}
