public static List <clsAssetsOfEmployee> AssetsListOfEmployee(string EmpID)
{
SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
List <clsAssetsOfEmployee> details = new List <clsAssetsOfEmployee>();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = @"SELECT ID, ProductCode, ProductName, SerialNumber, Quantity, AveragePrice, Total
FROM IMIS_VWEmployeeAsset where AssetStatus = 'Assigned' and ProductUsageTypeID=2 and EmployeeID='" + EmpID + "'";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
clsAssetsOfEmployee obj = new clsAssetsOfEmployee();
obj.ID = dtrow["ID"].ToString();
obj.ProductCode = dtrow["ProductCode"].ToString();
obj.ProductName = dtrow["ProductName"].ToString();
obj.SerialNumber = dtrow["SerialNumber"].ToString();
obj.Quantity = dtrow["Quantity"].ToString();
obj.AveragePrice = dtrow["AveragePrice"].ToString();
obj.Total = dtrow["Total"].ToString();
details.Add(obj);
}
return(details);
}
public static void ReturnAsset(clsAssetsOfEmployee Asset)
{
string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlTransaction tran = con.BeginTransaction();
SqlCommand cmd = new SqlCommand();
cmd.Transaction = tran;
cmd.Connection = con;
try
{
cmd.CommandText = @"update IMIS_tblAssignAssetToEmployeeDetail set AssetStatus='Returned',ReturnDate=getdate(),ReturnRemarks=N'" + Asset.ReturnRemarks + "',ReturnBy=N'" + Asset.ReturnBy + "' where ID=" + Asset.ID + "";
cmd.ExecuteNonQuery();
#region Stock Update/Insert
DataTable dt_Stock = new DataTable();
cmd.CommandText = @"update IMIS_tblStockInHand set Quantity=Quantity+" + Asset.Quantity + " where ProductCode='" + Asset.ProductCode + "'";
cmd.ExecuteNonQuery();
#endregion
tran.Commit();
}
catch (SqlException Sexp)
{
tran.Rollback();
con.Close();
}
catch (Exception ex)
{
con.Close();
}
finally
{
con.Close();
}
}
public static List <clsAssetsOfEmployee> AssetEdit(string ID)
{
string con = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
List <clsAssetsOfEmployee> details = new List <clsAssetsOfEmployee>();
SqlDataAdapter da = new SqlDataAdapter(@"SELECT ID, ProductCode, ProductName + ' , ' + SerialNumber AS ProductName, Quantity, AveragePrice, Total
FROM IMIS_VWEmployeeAsset where ID = " + ID + "", con);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
clsAssetsOfEmployee obj = new clsAssetsOfEmployee();
obj.ID = dtrow["ID"].ToString();
obj.ProductCode = dtrow["ProductCode"].ToString();
obj.ProductName = dtrow["ProductName"].ToString();
obj.Quantity = dtrow["Quantity"].ToString();
obj.AveragePrice = dtrow["AveragePrice"].ToString();
obj.Total = dtrow["Total"].ToString();
details.Add(obj);
}
// Newtonsoft.Json.js
return(details);
}
