public bool AddTPackingListDetails(TPackingListDetails tpackinglistdetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddTPackingListDetails"; cmd.Parameters.AddWithValue("@PackingListNo", tpackinglistdetails.PackingListNo); cmd.Parameters.AddWithValue("@FkVoucherNo", tpackinglistdetails.FkVoucherNo); cmd.Parameters.AddWithValue("@ItemNo", tpackinglistdetails.ItemNo); cmd.Parameters.AddWithValue("@Quantity", tpackinglistdetails.Quantity); cmd.Parameters.AddWithValue("@BagNo", tpackinglistdetails.BagNo); cmd.Parameters.AddWithValue("@CompanyNo", tpackinglistdetails.CompanyNo); cmd.Parameters.AddWithValue("@GroupNo", tpackinglistdetails.GroupNo); cmd.Parameters.AddWithValue("@FkStockTrnNo", tpackinglistdetails.FkStockTrnNo); cmd.Parameters.AddWithValue("@UserID", tpackinglistdetails.UserID); cmd.Parameters.AddWithValue("@UserDate", tpackinglistdetails.UserDate); commandcollection.Add(cmd); return(true); }
public bool DeleteTPackingListDetails(TPackingListDetails tpackinglistdetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteTPackingListDetails"; cmd.Parameters.AddWithValue("@PackingListNo", tpackinglistdetails.PackingListNo); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { return(false); } }
public TPackingListDetails ModifyTPackingListDetailsByID(int ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from TPackingListDetails where PackingListNo =" + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { TPackingListDetails MM = new TPackingListDetails(); while (dr.Read()) { MM.PackingListNo = Convert.ToInt32(dr["PackingListNo"]); if (!Convert.IsDBNull(dr["FkVoucherNo"])) { MM.FkVoucherNo = Convert.ToInt64(dr["FkVoucherNo"]); } if (!Convert.IsDBNull(dr["ItemNo"])) { MM.ItemNo = Convert.ToInt64(dr["ItemNo"]); } if (!Convert.IsDBNull(dr["Quantity"])) { MM.Quantity = Convert.ToDouble(dr["Quantity"]); } if (!Convert.IsDBNull(dr["BagNo"])) { MM.BagNo = Convert.ToString(dr["BagNo"]); } if (!Convert.IsDBNull(dr["CompanyNo"])) { MM.CompanyNo = Convert.ToInt64(dr["CompanyNo"]); } if (!Convert.IsDBNull(dr["StatusNo"])) { MM.StatusNo = Convert.ToInt64(dr["StatusNo"]); } if (!Convert.IsDBNull(dr["GroupNo"])) { MM.GroupNo = Convert.ToInt64(dr["GroupNo"]); } if (!Convert.IsDBNull(dr["UserID"])) { MM.UserID = Convert.ToInt64(dr["UserID"]); } if (!Convert.IsDBNull(dr["UserDate"])) { MM.UserDate = Convert.ToDateTime(dr["UserDate"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new TPackingListDetails()); }