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