public Yarn_Count Get_Yarn_Count_By_Id(int ID) { Yarn_Count _Yarn_Count = new Yarn_Count(); DataTable dt = Yarn_Count_DA.Get_Yarn_Count_By_Id(ID); foreach (DataRow row in dt.Rows) { _Yarn_Count.ID = ID; _Yarn_Count.Count = int.Parse(row["Count"].ToString()); } return _Yarn_Count; }
public static string Insert(Yarn_Count _Yarn_Count) { DbCommand command = Catalog_Access.CreateCommand(); command.CommandText = "sp_insert_Yarn_Count"; DbParameter param; param = command.CreateParameter(); param.ParameterName = "@Count"; param.Value = _Yarn_Count.Count; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CreatedBy"; param.Value = _Yarn_Count.CreatedBy; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Return"; param.DbType = DbType.String; param.Size = 2; param.Direction = ParameterDirection.Output; command.Parameters.Add(param); Catalog_Access.ExecuteNonQuery(command); string Return = command.Parameters["@Return"].Value.ToString(); return Return; }
public string Insert(int Count) { Yarn_Count _Yarn_Count = new Yarn_Count(); _Yarn_Count.Count = Count; _Yarn_Count.CreatedBy = Session["User"].ToString(); return Yarn_Count_DA.Insert(_Yarn_Count); }
public string Update(int ID, int Count) { Yarn_Count _Yarn_Count = new Yarn_Count(); _Yarn_Count.ID = ID; _Yarn_Count.Count = Count; _Yarn_Count.UpdatedBy = Session["User"].ToString(); if (_Yarn_Count.UpdatedBy.ToString().ToUpper() == ("Mr. Asif").ToString().ToUpper() || _Yarn_Count.UpdatedBy.ToString().ToUpper() == ("Saud Piracha").ToString().ToUpper()) { return Yarn_Count_DA.Update(_Yarn_Count); } else { return "-1"; } }