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; }