public bool AddTranspotorDetail(TranspotorDetail mTranspotorDetail) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddTranspotorDetail"; cmd.Parameters.AddWithValue("@PkTranspotorDetail", mTranspotorDetail.PkTranspotorDetail); //cmd.Parameters.AddWithValue("@FKEWayNo", mTranspotorDetail.FKEWayNo); //cmd.Parameters.AddWithValue("@FkVoucherNo", mTranspotorDetail.FkVoucherNo); cmd.Parameters.AddWithValue("@NoOfQty", mTranspotorDetail.NoOfQty); cmd.Parameters.AddWithValue("@BalancedQty", mTranspotorDetail.BalancedQty); cmd.Parameters.AddWithValue("@ReceivedQty", mTranspotorDetail.ReceivedQty); cmd.Parameters.AddWithValue("@msg", mTranspotorDetail.msg); //if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) //{ // return true; //} //else //{ // mTranspotorDetail.msg = ObjTrans.ErrorMessage; // return false; //} commandcollection.Add(cmd); return(true); }
public TranspotorDetail ModifyTranspotorDetailByID(long ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; //sql = "Select * from TranspotorDetail where FKTranspotorDetail =" + ID; sql = "Select * from TranspotorDetail where FkVoucherNo = " + 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) { TranspotorDetail MM = new TranspotorDetail(); while (dr.Read()) { MM.PkTranspotorDetail = Convert.ToInt32(dr["PkTranspotorDetail"]); //if (!Convert.IsDBNull(dr["FKEWayNo"])) MM.FKEWayNo = Convert.ToInt32(dr["FKEWayNo"]); if (!Convert.IsDBNull(dr["FkVoucherNo"])) { MM.FkVoucherNo = Convert.ToInt32(dr["FkVoucherNo"]); } if (!Convert.IsDBNull(dr["NoOfQty"])) { MM.NoOfQty = Convert.ToDouble(dr["NoOfQty"]); } if (!Convert.IsDBNull(dr["BalancedQty"])) { MM.BalancedQty = Convert.ToDouble(dr["BalancedQty"]); } if (!Convert.IsDBNull(dr["ReceivedQty"])) { MM.ReceivedQty = Convert.ToDouble(dr["ReceivedQty"]); } if (!Convert.IsDBNull(dr["RemarkQty"])) { MM.RemarkQty = Convert.ToString(dr["RemarkQty"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new TranspotorDetail()); }
//public bool AddMTranspotorDetail(MTranspotorDetail mTranspotorDetail) //{ // SqlCommand cmd; // cmd = new SqlCommand(); // cmd.CommandType = CommandType.StoredProcedure; // cmd.CommandText = "AddMTranspotorDetail"; // cmd.Parameters.AddWithValue("@UOMNo", mTranspotorDetail.UOMNo); // cmd.Parameters.AddWithValue("@UOMName", muom.UOMName); // cmd.Parameters.AddWithValue("@UOMShortCode", muom.UOMShortCode); // cmd.Parameters.AddWithValue("@IsActive", muom.IsActive); // cmd.Parameters.AddWithValue("@UserID", muom.UserID); // cmd.Parameters.AddWithValue("@UserDate", muom.UserDate); // cmd.Parameters.AddWithValue("@CompanyNo", DBGetVal.FirmNo); // cmd.Parameters.AddWithValue("@GlobalCode", muom.GlobalCode); // //cmd.Parameters.AddWithValue("@ModifiedBy", muom.ModifiedBy); // if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) // { // return true; // } // else // { // muom.msg = ObjTrans.ErrorMessage; // return false; // } //} public bool DeleteTranspotorDetail(TranspotorDetail mTranspotorDetail) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteTranspotorDetail"; cmd.Parameters.AddWithValue("@PkTranspotorDetail", mTranspotorDetail.PkTranspotorDetail); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { mTranspotorDetail.msg = ObjTrans.ErrorMessage; return(false); } }