//Position Table Partial View
public ActionResult Get_PositionTable()
{
FM_Position_Position model = new FM_Position_Position();
List <PositionList> tbl_Position = new List <PositionList>();
var SQLQuery = "SELECT * FROM DB_TOSS.dbo.Signatory_PositionTable order by PositionName asc";
//SQLQuery += " WHERE (IsActive != 0)";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_PositionList]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
tbl_Position.Add(new PositionList()
{
PositionID = GlobalFunction.ReturnEmptyInt(dr[0]),
PositionName = GlobalFunction.ReturnEmptyString(dr[1]),
PositionCode = GlobalFunction.ReturnEmptyString(dr[2]),
});
}
}
Connection.Close();
}
model.getPositionList = tbl_Position.ToList();
return(PartialView("_PositionTable", model.getPositionList));
}
//Delete Position Table
public ActionResult DeletePosition(FM_Position_Position model, int PositionID)
{
Signatory_PositionTable tblPosition = (from e in TOSSDB.Signatory_PositionTable where e.PositionID == PositionID select e).FirstOrDefault();
TOSSDB.Signatory_PositionTable.Remove(tblPosition);
TOSSDB.SaveChanges();
return(RedirectToAction("Index"));
}
//Get Position Update
public ActionResult Get_UpdatePosition(FM_Position_Position model, int PositionID)
{
Signatory_PositionTable tblPosition = (from e in TOSSDB.Signatory_PositionTable where e.PositionID == PositionID select e).FirstOrDefault();
model.getPositioncolumns.PositionID = tblPosition.PositionID;
model.getPositioncolumns.PositionName = tblPosition.PositionName;
model.getPositioncolumns.PositionCode = tblPosition.PositionCode;
return(PartialView("_UpdatePosition", model));
}
public ActionResult UpdatePosition(FM_Position_Position model)
{
Signatory_PositionTable tblPosition = (from e in TOSSDB.Signatory_PositionTable where e.PositionID == model.getPositioncolumns.PositionID select e).FirstOrDefault();
tblPosition.PositionName = model.getPositioncolumns.PositionName;
tblPosition.PositionCode = model.getPositioncolumns.PositionCode;
TOSSDB.Entry(tblPosition);
TOSSDB.SaveChanges();
return(PartialView("_UpdatePosition", model));
}
//Add Position
public JsonResult AddPosition(FM_Position_Position model)
{
Signatory_PositionTable tblPositionName = new Signatory_PositionTable();
tblPositionName.PositionName = GlobalFunction.ReturnEmptyString(model.getPositioncolumns.PositionName);
tblPositionName.PositionCode = GlobalFunction.ReturnEmptyString(model.getPositioncolumns.PositionCode);
TOSSDB.Signatory_PositionTable.Add(tblPositionName);
TOSSDB.SaveChanges();
return(Json(tblPositionName));
}
//Get Add Position Partial View
public ActionResult Get_AddPosition()
{
FM_Position_Position model = new FM_Position_Position();
return(PartialView("_AddPosition", model));
}