public ReqMaster getReqMID(SqlConnection con, int ReqMID) { DataTable dt = new DataTable(); ReqMaster obReqMaster = new ReqMaster(); try { SqlDataAdapter da = new SqlDataAdapter("Select * from T_Requisition_Master Where ReqMID = " + @ReqMID.ToString(), con); da.SelectCommand.Parameters.Add("@ReqMID", SqlDbType.Int).Value = ReqMID; da.Fill(dt); da.Dispose(); if (dt.Rows.Count == 0) { return(null); } obReqMaster.ReqMID = Convert.ToInt32(dt.Rows[0].Field <object>("ReqMID")); obReqMaster.ReqNo = dt.Rows[0].Field <object>("ReqNo").ToString(); obReqMaster.ReqSectionID = Convert.ToInt32(dt.Rows[0].Field <object>("ReqSectionID")); obReqMaster.ReqDate = Convert.ToDateTime(dt.Rows[0].Field <object>("ReqDate")); obReqMaster.ReqBy = dt.Rows[0].Field <object>("ReqBy").ToString(); obReqMaster.Remarks = dt.Rows[0].Field <object>("Remarks").ToString(); } catch (Exception ex) { throw new Exception(ex.Message); } return(obReqMaster); }
public int SaveUpdateReqMaster(ReqMaster obReqMaster, SqlConnection con, SqlTransaction trans) { int ID = 0; SqlCommand com = null; try { com = new SqlCommand("spSaveUpdateReqMaster", con, trans); com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@ReqMID", SqlDbType.Int).Value = obReqMaster.ReqMID; com.Parameters.Add("@ReqNo", SqlDbType.VarChar, 100).Value = obReqMaster.ReqNo; com.Parameters.Add("@ReqDate", SqlDbType.DateTime).Value = obReqMaster.ReqDate; com.Parameters.Add("@ReqSectionID", SqlDbType.Int).Value = obReqMaster.ReqSectionID; com.Parameters.Add("@ReqBy", SqlDbType.VarChar, 500).Value = obReqMaster.ReqBy; com.Parameters.Add("@Remarks", SqlDbType.VarChar, 500).Value = obReqMaster.Remarks; com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = LogInInfo.CompanyID; com.Parameters.Add("@UserID", SqlDbType.Int).Value = LogInInfo.UserID; com.ExecuteNonQuery(); if (obReqMaster.ReqMID == 0) { SqlCommand cmd = new SqlCommand("SELECT ISNULL(MAX(ReqMID),0) FROM T_Requisition_Master", con, trans); ID = Convert.ToInt32(cmd.ExecuteScalar()); } else { ID = obReqMaster.ReqMID; } } catch (Exception ex) { throw new Exception(ex.Message); } return(ID); }