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