public int CreateBoxNumber(BoxNumber newBoxNumber)
{
int result = -1;
try
{
conn = db.openConn();
tr = conn.BeginTransaction();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO box_numbers(complete_no,quantity,suplier,date_create,user_create_name,status)");
sb.Append(" VALUES (@complete_no,@quantity,@suplier,@date_create,@user_create_name,@status)");
string sqlsave;
sqlsave = sb.ToString();
comm = new SqlCommand();
comm.Connection = conn;
comm.Transaction = tr;
comm.CommandText = sqlsave;
comm.Parameters.Clear();
comm.Parameters.Add("@complete_no", SqlDbType.NVarChar).Value = newBoxNumber.CompleteNo;
comm.Parameters.Add("@quantity", SqlDbType.NVarChar).Value = newBoxNumber.Quantity;
comm.Parameters.Add("@suplier", SqlDbType.NVarChar).Value = newBoxNumber.Suplier;
comm.Parameters.Add("@date_create", SqlDbType.NVarChar).Value = newBoxNumber.DateCreate;
comm.Parameters.Add("@user_create_name", SqlDbType.NVarChar).Value = newBoxNumber.UserCreateName;
comm.Parameters.Add("@status", SqlDbType.NVarChar).Value = newBoxNumber.Status;
comm.ExecuteNonQuery();
tr.Commit();
result = 1;
}
catch (Exception ex)
{
tr.Rollback();
conn.Close();
return result;
throw ex;
}
finally
{
conn.Close();
}
return result;
}
public int UpdateBoxLabelNumber(BoxNumber _boxNumber)
{
int result = -1;
try
{
conn = db.openConn();
tr = conn.BeginTransaction();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" UPDATE box_numbers ");
sb.Append(" SET quantity='" + _boxNumber.Quantity + "',");
sb.Append(" suplier='" + _boxNumber.Suplier + "'");
sb.Append(" WHERE (complete_no='" + _boxNumber.CompleteNo + "')");
string sqlUpdate;
sqlUpdate = sb.ToString();
comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = sqlUpdate;
comm.Transaction = tr;
comm.Parameters.Clear();
comm.ExecuteNonQuery();
tr.Commit();
result = 1;
}
catch (Exception ex)
{
tr.Rollback();
conn.Close();
return result;
throw ex;
}
finally
{
conn.Close();
}
return result;
}
public List<BoxNumber> GetByCompleteNo(string _completeno)
{
List<BoxNumber> boxNumbers = new List<BoxNumber>();
BoxNumber fbl = null;
try
{
conn = db.openConn();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" select id,complete_no,quantity,suplier,date_create,user_create_name,status from dbo.box_numbers");
sb.Append(" where complete_no ='" + _completeno + "'");
string sql;
sql = sb.ToString();
comm = new SqlCommand();
comm.CommandText = sql;
comm.CommandType = CommandType.Text;
comm.Connection = conn;
dr = comm.ExecuteReader();
if (dr.HasRows)
{
DataTable dt = new DataTable();
dt.Load(dr);
foreach (DataRow drw in dt.Rows)
{
fbl = new BoxNumber();
fbl.ID = 0;
fbl.CompleteNo = drw["complete_no"].ToString();
fbl.Quantity = drw["quantity"].ToString();
fbl.Suplier = drw["suplier"].ToString();
fbl.DateCreate =Convert.ToDateTime(drw["date_create"].ToString());
fbl.UserCreateName = drw["user_create_name"].ToString();
fbl.Status = drw["status"].ToString();
boxNumbers.Add(fbl);
}
}
}
catch (Exception ex)
{
dr.Close();
conn.Close();
return null;
throw ex;
}
finally
{
conn.Close();
}
return boxNumbers;
}
