public ActionResult StockDet(string id)
{
if (string.IsNullOrEmpty(id))
{
return(View());
}
else
{
string sSQL = " SELECT * FROM icstk " +
"where AUTOINC ='" + id + "'";
using (MySqlDataReader reader = conn2.ExecuteReader(sSQL))
{
if (reader.Read()) // If you're expecting more than one line, change this to while(reader.Read()).
{
ICModel rec = new ICModel
{
STKCODE = reader["STKCODE"].ToString(),
PART = reader["PART"].ToString(),
DT_EDIT = reader["DT_EDIT"].ToString(),
};
ViewBag.FieldValue = rec;
return(View());
}
}
}
return(View());
}
public ActionResult LocationDet(string id, ICModel viewModel)
{
if (id == "Save")
{
sSQL = " SELECT * FROM icloc where LOC_CODE ='" + viewModel.LOC_CODE + "'";
using (MySqlDataReader reader = conn2.ExecuteReader(sSQL))
{
if (reader.Read())
{
return(Json(new { status = "fail", message = "Location Code already exists", fieldname = "LOC_CODE" }));
}
else
{
sSQL = " INSERT into icloc" +
" (LOC_CODE, LOC_PART, EDIT_ID,DT_EDIT,CREATE_ID,DT_CREATE)" +
" values ( " +
viewModel.LOC_CODE + " , " +
viewModel.LOC_PART + " , " +
Session["USER_ID"] + " , " +
DateTime.Now + " , " +
Session["USER_ID"] + " , " +
DateTime.Now + " ) ";
conn2.ExecuteQuery(sSQL);
conn2.Close();
return(Json(new { status = "saved", message = viewModel.LOC_CODE }));
}
}
}
else if (id == "Update")
{
sSQL = " UPDATE icloc set" +
" LOC_PART= " + viewModel.LOC_PART + " , " +
" EDIT_ID= " + Session["USER_ID"] + " , " +
" DT_EDIT= " + DateTime.Now +
" WHERE LOC_CODE = " + viewModel.LOC_CODE;
conn2.ExecuteQuery(sSQL);
conn2.Close();
return(Json(new { status = "updated", message = viewModel.LOC_CODE }));
}
else
{
sSQL = " DELETE FROM icloc" +
" WHERE LOC_CODE = " + viewModel.LOC_CODE;
conn2.ExecuteQuery(sSQL);
conn2.Close();
return(Json(new { status = "deleted", message = viewModel.LOC_CODE }));
}
}
public ActionResult CurrencyDet(string id, string tableName)
{
TABLENAME = tableName;
if (TABLENAME == "arcurr")
{
ViewBag.Title = "Debtor Currency Details";
}
else
{
ViewBag.Title = "Vendor Currency Details";
//ViewBag.sDebOrVen = "Ven";
}
if (string.IsNullOrEmpty(id))
{
return(View());
}
else
{
sSQL = " SELECT * FROM " + TABLENAME +
"where AUTOINC ='" + id + "'";
using (MySqlDataReader reader = conn2.ExecuteReader(sSQL))
{
if (reader.Read()) // If you're expecting more than one line, change this to while(reader.Read()).
{
ICModel rec = new ICModel
{
CURR_CODE = reader["CURR_CODE"].ToString(),
CURR_PART = reader["CURR_PART"].ToString(),
RATE = reader["CURR_PART"].ToString(),
DT_EDIT = reader["DT_EDIT"].ToString(),
};
ViewBag.FieldValue = rec;
return(View());
}
}
}
return(View());
}
public ActionResult CurrencyDet(string id, ICModel viewModel)
//public ActionResult CurrencyDet(string id, string sTableName, ICModel viewModel)
{
string sDebOrVen;
if (TABLENAME == "arcurr")
{
sDebOrVen = "Deb";
}
else
{
sDebOrVen = "Ven";
}
if (id == "Save")
{
sSQL = " SELECT * FROM " + TABLENAME +
" where CURR_CODE ='" + viewModel.CURR_CODE + "'";
using (MySqlDataReader reader = conn2.ExecuteReader(sSQL))
{
if (reader.Read())
{
return(Json(new { status = "fail", message = "Currency Code already exists", fieldname = "CURR_CODE" }));
}
else
{
sSQL = " INSERT into " + TABLENAME +
" (CURR_CODE, CURR_PART, RATE, EDIT_ID,DT_EDIT,CREATE_ID,DT_CREATE)" +
" values " +
viewModel.CURR_CODE + " , " +
viewModel.CURR_PART + " , " +
Session["USER_ID"] + " , " +
DateTime.Now + " , " +
Session["USER_ID"] + " , " +
DateTime.Now + " ) ";
conn2.ExecuteQuery(sSQL);
conn2.Close();
return(Json(new { status = "saved", message = viewModel.CURR_CODE, DebOrVen = sDebOrVen }));
}
}
}
else if (id == "Update")
{
sSQL = " UPDATE " + TABLENAME + " set" +
" CURR_PART= " + viewModel.CURR_PART + " , " +
" RATE= " + viewModel.RATE + " , " +
" EDIT_ID= " + Session["USER_ID"] + " , " +
" DT_EDIT= " + DateTime.Now +
" WHERE CURR_CODE = " + viewModel.CURR_CODE;
conn2.ExecuteQuery(sSQL);
conn2.Close();
return(Json(new { status = "updated", message = viewModel.CURR_CODE, DebOrVen = sDebOrVen }));
}
else
{
sSQL = " DELETE from " + TABLENAME +
" WHERE CURR_CODE = " + viewModel.CURR_CODE;
conn2.ExecuteQuery(sSQL);
conn2.Close();
return(Json(new { status = "deleted", message = viewModel.CURR_CODE, DebOrVen = sDebOrVen }));
}
}