public IActionResult RenderMenu() { SaveIndent saveIndent = new SaveIndent(); ViewBag.IndentNo = indentNo; return(PartialView("_MenuBar", saveIndent.GridIndents)); }
private SaveIndent GetIndent(long Id) { SaveIndent saveIndent = new SaveIndent(); long ApprovalId = Convert.ToInt64(HttpContext.Session.GetString(SessionUserID)); try { List <GridIndent> gridIndents = new List <GridIndent>(); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnection"].ToString())) { connection.Open(); SqlCommand testCMD = new SqlCommand("GetIndent", connection); testCMD.CommandType = CommandType.StoredProcedure; testCMD.Parameters.Add(new SqlParameter("@IndentID", System.Data.SqlDbType.BigInt, 50) { Value = Id }); testCMD.Parameters.Add(new SqlParameter("@UserID", System.Data.SqlDbType.VarChar, 300) { Value = ApprovalId }); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(testCMD); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); int counter = 0; while (counter < dataSet.Tables[0].Rows.Count) { saveIndent.Date = Convert.ToDateTime(dataSet.Tables[0].Rows[counter]["Date"]); saveIndent.LocationCode = Convert.ToInt64(dataSet.Tables[0].Rows[counter]["LocationCode"]); saveIndent.IndentRemarks = Convert.ToString(dataSet.Tables[0].Rows[counter]["Remarks"]); saveIndent.ApproverName = Convert.ToString(dataSet.Tables[0].Rows[counter]["Approver"]); saveIndent.ApprovalID = Convert.ToInt64(dataSet.Tables[0].Rows[counter]["Approver ID"]); saveIndent.ApprovalStatus = Convert.ToString(dataSet.Tables[0].Rows[counter]["ApprovalStatus"]); GridIndent gridIndent = new GridIndent(); gridIndent.SlNo = counter + 1; gridIndent.ItemCategoryName = Convert.ToString(dataSet.Tables[0].Rows[counter]["ItemCategoryName"]); gridIndent.ItemName = Convert.ToString(dataSet.Tables[0].Rows[counter]["ItemName"]); gridIndent.ItemCode = Convert.ToString(dataSet.Tables[0].Rows[counter]["ItemCode"]); gridIndent.Units = Convert.ToString(dataSet.Tables[0].Rows[counter]["Unit"]); gridIndent.Description = Convert.ToString(dataSet.Tables[0].Rows[counter]["Description"]); gridIndent.Technical_Specifications = Convert.ToString(dataSet.Tables[0].Rows[counter]["TechnicalSpecification"]); gridIndent.Quantity = Convert.ToInt32(dataSet.Tables[0].Rows[counter]["Quantity"]); gridIndent.Remarks = Convert.ToString(dataSet.Tables[0].Rows[counter]["Item Remarks"]); gridIndents.Add(gridIndent); saveIndent.Email = Convert.ToString(dataSet.Tables[0].Rows[counter]["Email"]); counter++; } dataSet.Dispose(); } saveIndent.GridIndents = gridIndents; return(saveIndent); } catch (Exception ex) { ////log.Error("Error while fetching Indent information: " + ex.StackTrace); return(saveIndent); } }
public SaveIndent GetIndentDetails(long Id) { SaveIndent saveIndent = GetIndent(Id); return(saveIndent); }