public bool AddMRacDeatils(MRacDetils mRacDetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMRacDetails"; cmd.Parameters.AddWithValue("@RacDetailsNo", mRacDetails.RacDetailsNo); cmd.Parameters.AddWithValue("@ItemNo", mRacDetails.ItemNo); // cmd.Parameters.AddWithValue("@RacInvNo", mRacDetails.RacInvNo); cmd.Parameters.AddWithValue("@RacDocNo", mRacDetails.RacDocNo); cmd.Parameters.AddWithValue("@Quantity", mRacDetails.Quantity); cmd.Parameters.AddWithValue("@UomNo", mRacDetails.UOMNo); cmd.Parameters.AddWithValue("@GodOwnNo", mRacDetails.GodOwnNo); //cmd.Parameters.AddWithValue("@StateNo", mcity.StateNo); //cmd.Parameters.AddWithValue("@RegionNo", mcity.RegionNo); cmd.Parameters.AddWithValue("@IsActive", mRacDetails.IsActive); cmd.Parameters.AddWithValue("@UserID", mRacDetails.UserID); cmd.Parameters.AddWithValue("@UserDate", mRacDetails.UserDate); // cmd.Parameters.AddWithValue("@CompanyNo", mcity.CompanyNo); //cmd.Parameters.AddWithValue("@ModifiedBy", mcity.ModifiedBy); //if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) //{ // return true; //} //else //{ // mRacDetails.msg = ObjTrans.ErrorMessage; // return false; //} //SqlParameter outParameter = new SqlParameter(); //outParameter.ParameterName = "@ReturnID"; //outParameter.Direction = ParameterDirection.Output; //outParameter.DbType = DbType.Int32; //cmd.Parameters.Add(outParameter); commandcollection.Add(cmd); return(true); }
public bool DeleteMRaC(MRacDetils mRacDetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteMRac"; cmd.Parameters.AddWithValue("@RacDocNo", mRacDetails.RacDocNo); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { mRacDetails.msg = ObjTrans.ErrorMessage; return(false); } }
public MRacDetils ModifyMRackByID(long ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from mRacdetails where RacDetailsNo =" + 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) { MRacDetils MM = new MRacDetils(); while (dr.Read()) { MM.RacInvNo = Convert.ToInt32(dr["RacDetailsNo"]); if (!Convert.IsDBNull(dr["ItemNo"])) { MM.ItemNo = Convert.ToInt32(dr["ItemNo"]); } if (!Convert.IsDBNull(dr["Quantity"])) { MM.Quantity = Convert.ToInt32(dr["Quantity"]); } if (!Convert.IsDBNull(dr["UOMNo"])) { MM.UOMNo = Convert.ToInt32(dr["UOMNo"]); } //if (!Convert.IsDBNull(dr["CityShortCode"])) MM.CityShortCode = Convert.ToString(dr["CityShortCode"]); // if (!Convert.IsDBNull(dr["CityLangName"])) MM.CityLangName = Convert.ToString(dr["CityLangName"]); // if (!Convert.IsDBNull(dr["CountryNo"])) MM.CountryNo = Convert.ToInt64(dr["CountryNo"]); // if (!Convert.IsDBNull(dr["StateNo"])) MM.StateNo = Convert.ToInt64(dr["StateNo"]); // if (!Convert.IsDBNull(dr["RegionNo"])) MM.RegionNo = Convert.ToInt64(dr["RegionNo"]); if (!Convert.IsDBNull(dr["IsActive"])) { MM.IsActive = Convert.ToBoolean(dr["IsActive"]); } if (!Convert.IsDBNull(dr["UserID"])) { MM.UserID = Convert.ToInt64(dr["UserID"]); } if (!Convert.IsDBNull(dr["UserDate"])) { MM.UserDate = Convert.ToDateTime(dr["UserDate"]); } //if (!Convert.IsDBNull(dr["ModifiedBy"])) MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]); // if (!Convert.IsDBNull(dr["CompanyNo"])) MM.CompanyNo = Convert.ToInt64(dr["CompanyNo"]); } dr.Close(); return(MM); } else { dr.Close(); } return(new MRacDetils()); }