public IList <BO.ProductGeneric> GetProductGenericByObject(BO.ProductGeneric objProductGeneric, Int32 pageIndex, Int32 pageSize, String orderBy, String sortindex) { try { return(new List <POS.BO.ProductGeneric>()); } catch (Exception ex) { throw ex; } }
private IList <POS.BO.ProductGeneric> GetProductGenericList(Int64?PGenericID) { try { SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); // da.SelectCommand.Parameters.Add("@PGenericID", System.Data.SqlDbType.Int).Value = PGenericID; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; da.SelectCommand.CommandText = "POS_SP_GET_GETProductGeneric"; if (con.State == ConnectionState.Closed) { con.Open(); } DataSet ds = new DataSet(); da.Fill(ds); if (con.State == ConnectionState.Open) { con.Close(); } DataTable dt = ds.Tables[0]; List <BO.ProductGeneric> objProductGenericList = new List <BO.ProductGeneric>(); BO.ProductGeneric objProductGeneric = null; Int32 index = 1; foreach (DataRow row in dt.Rows) { objProductGeneric = new BO.ProductGeneric(); objProductGeneric.Sln = index++; objProductGeneric.PGenericID = Convert.ToInt32(row["GenericID"]); objProductGeneric.GenericName = Convert.ToString(row["GenericName"]); objProductGeneric.GenericDescription = Convert.ToString(row["Description"]); objProductGenericList.Add(objProductGeneric); } return(objProductGenericList); } catch (Exception ex) { throw ex; } }
public Int32 Update(BO.ProductGeneric objProductGeneric, Int32 PGenericID) { try { Int32 returnStatus = 0; SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); da.SelectCommand.Parameters.Add("@GenericID", System.Data.SqlDbType.Int).Value = objProductGeneric.PGenericID; da.SelectCommand.Parameters.Add("@GenericName", System.Data.SqlDbType.VarChar, 100).Value = objProductGeneric.GenericName; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; da.SelectCommand.CommandText = "DCR_SP_UDCRTE_ProductGeneric"; if (con.State == ConnectionState.Closed) { con.Open(); } if (da.SelectCommand.ExecuteNonQuery() == 1) { returnStatus = 1; } else { returnStatus = 0; } if (con.State == ConnectionState.Open) { con.Close(); } return(returnStatus); } catch (Exception ex) { throw ex; } }
public Int32 Insert(BO.ProductGeneric objProductGeneric) { try { Int32 returnStatus = 0; SqlConnection con = CreateCon(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(); da.SelectCommand.Parameters.Add("@GenericName", SqlDbType.VarChar, 100).Value = objProductGeneric.GenericName; da.SelectCommand.Parameters.Add("@GenericDescription", SqlDbType.VarChar, 500).Value = objProductGeneric.GenericDescription; da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Connection = con; da.SelectCommand.CommandText = "[POS_SET_SP_INSERT_SET_ProductGeneric]"; if (con.State == ConnectionState.Closed) { con.Open(); } if (da.SelectCommand.ExecuteNonQuery() == 1) { returnStatus = 1; } else { returnStatus = 0; } if (con.State == ConnectionState.Open) { con.Close(); } return(returnStatus); } catch (Exception ex) { throw ex; } }
public IList <BO.ProductGeneric> GetProductGenericByObject(BO.ProductGeneric objProductGeneric, Int32 pageIndex, Int32 pageSize, String orderBy, String sortindex) { return(_iProductGeneric.GetProductGenericByObject(objProductGeneric, pageIndex, pageSize, orderBy, sortindex)); }
public Int32 Update(BO.ProductGeneric objProductGeneric, Int32 PGenericID) { return(_iProductGeneric.Update(objProductGeneric, PGenericID)); }
public Int32 Update(BO.ProductGeneric objProductGeneric) { return(_iProductGeneric.Update(objProductGeneric)); }
public Int32 Insert(BO.ProductGeneric objProductGeneric) { return(_iProductGeneric.Insert(objProductGeneric)); }