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