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