public JsonResult execd(string procedure, Dictionary <string, object> parameters, string selectorsave = "select")
{
List <SqlParameter> lstpr = new List <SqlParameter>();
parameters.ToList().ForEach(p =>
{
lstpr.Add(new SqlParameter("@" + p.Key, p.Value));
});
try
{
if (selectorsave != "select")
{
int maxwono = DataOpration.SaveData(procedure, lstpr.ToArray());
return(Json(maxwono, JsonRequestBehavior.AllowGet));
}
else if (selectorsave == "select")
{
DataTable dt = DataOpration.GetDataTable(procedure, lstpr.ToArray());
// string ddd = DataOpration.GetJsonData(procedure, lstpr.ToArray());
return(Json(DataOpration.DataTableTojsonstring(dt), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
// TempData["msg"] = "<script>alert('Error occured contacc to MyCAD!!!');</script>";
// Logger.LogSendMail(ex.Message + " Stacktrace = " + ex.StackTrace + " Source= " + ex.InnerException + " " + ex.TargetSite);
Global.ErrorHandlerClass.LogError(ex);
}
return(null);
}
public JsonResult insertUser(string fName, string lName, string uName, string password, string uType, string department, string email, string contactNumber)
{
try
{
int result = 0;
DataOpration.SaveData("uspUser", new SqlParameter("@Action", "insertUser"),
new SqlParameter("@FirstName", fName.Trim()), new SqlParameter("@LastName", lName.Trim()),
new SqlParameter("@UserName", uName.Trim()), new SqlParameter("@Password", password.Trim()),
new SqlParameter("@UserType", uType.Trim()), new SqlParameter("@DepartmentID", department.Trim()),
new SqlParameter("@Email", email.Trim()),
new SqlParameter("@ContactNumber", contactNumber.Trim()));
return(Json("", JsonRequestBehavior.AllowGet));
//DatasController DatasController = new DatasController();
//Dictionary<string, object> parameters = new Dictionary<string, object>();
//parameters.Add("Action", "insertUser");
//parameters.Add("FirstName", fName.Trim());
//parameters.Add("LastName", lName.Trim());
//parameters.Add("UserName", uName.Trim());
//parameters.Add("Password", password.Trim());
//parameters.Add("UserType", uType.Trim());
//parameters.Add("DepartmentID", department.Trim());
//parameters.Add("Email", email.Trim());
//parameters.Add("ContactNumber", contactNumber.Trim());
//DatasController.Dispose();
//return DatasController.execd("uspUser", parameters);
}
catch (Exception ex)
{
Global.ErrorHandlerClass.LogError(ex);
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public JsonResult exec(string procedure, string parameters, string selectorsave = "select")
{
List <SqlParameter> lstpr = new List <SqlParameter>();
if (!string.IsNullOrEmpty(parameters))
{
parameters.Split('^').ToList().ForEach(p =>
{
var vr = p.Split('~');
lstpr.Add(new SqlParameter("@" + vr[0], vr[1]));
});
}
try
{
if (selectorsave != "select")
{
int maxwono = DataOpration.SaveData(procedure, lstpr.ToArray());
return(Json(maxwono, JsonRequestBehavior.AllowGet));
}
else if (selectorsave == "select")
{
DataTable dt = DataOpration.GetDataTable(procedure, lstpr.ToArray());
return(Json(DataOpration.DataTableTojsonstring(dt), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
// TempData["msg"] = "<script>alert('Error occured contacc to MyCAD!!!');</script>";
//Logger.LogSendMail(ex.Message + " Stacktrace = " + ex.StackTrace + " Source= " + ex.InnerException + " " + ex.TargetSite);
Global.ErrorHandlerClass.LogError(ex);
}
return(null);
}
public List <Dictionary <string, object> > GetDictionarys(string procedure, Dictionary <string, object> parameters, string selectorsave = "select")
{
List <Dictionary <string, object> > result = new List <Dictionary <string, object> >();
List <SqlParameter> lstpr = new List <SqlParameter>();
parameters.ToList().ForEach(p =>
{
lstpr.Add(new SqlParameter("@" + p.Key, p.Value));
});
try
{
if (selectorsave != "select")
{
int maxwono = DataOpration.SaveData(procedure, lstpr.ToArray());
Dictionary <string, object> art = new Dictionary <string, object>();
art.Add("maxid", maxwono);
result.Add(art);
return(result);
}
else if (selectorsave == "select")
{
DataTable dt = DataOpration.GetDataTable(procedure, lstpr.ToArray());
result = DataOpration.DataTableTojsonstring(dt);
return(result);
}
}
catch (Exception ex)
{
// TempData["msg"] = "<script>alert('Error occured contacc to MyCAD!!!');</script>";
// Logger.LogSendMail(ex.Message + " Stacktrace = " + ex.StackTrace + " Source= " + ex.InnerException + " " + ex.TargetSite);
Global.ErrorHandlerClass.LogError(ex);
}
return(result);
}
public JsonResult savedatapermission(string UserId, string submenuid, string isaddcheck, string add, string iseditcheck,
string edit, string isdelcheck, string del, string isviewcheck, string view, string isapprovalcheck, string approval,
string isprintcheck, string print, string isdownloadcheck, string download, string issendmailcheck, string sendmail)
{
if ((isaddcheck != null) || (add != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", isaddcheck.Trim()), new SqlParameter("@ActionID", add.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((iseditcheck != null) || (edit != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", iseditcheck.Trim()), new SqlParameter("@ActionID", edit.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((isdelcheck != null) || (del != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", isdelcheck.Trim()), new SqlParameter("@ActionID", del.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((isviewcheck != null) || (view != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", isviewcheck.Trim()), new SqlParameter("@ActionID", view.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((isapprovalcheck != null) || (approval != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", isapprovalcheck.Trim()), new SqlParameter("@ActionID", approval.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((isprintcheck != null) || (print != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", isprintcheck.Trim()), new SqlParameter("@ActionID", print.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((isdownloadcheck != null) || (download != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", isdownloadcheck.Trim()), new SqlParameter("@ActionID", download.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
if ((issendmailcheck != null) || (sendmail != null))
{
DataOpration.SaveData("uspAuthorizePermission", new SqlParameter("@SubMenuId", submenuid.Trim()),
new SqlParameter("@IsAction", issendmailcheck.Trim()), new SqlParameter("@ActionID", sendmail.Trim()),
new SqlParameter("@UserID", UserId.Trim()));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public JsonResult getid(string type)
{
string ids = "";
var dt = DataOpration.GetDataTable("DeliveryChallan_sp", new SqlParameter("@Action", "lastdispachno"), new SqlParameter("@dctype", type.Trim()));
var result = DataOpration.DataTableTojsonstring(dt);
// result[0].Values;
if (type == "Job Disptach")
{
if (result.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
string value = row["dispachno"].ToString();
string[] split = Regex.Split(value, "-");
Int64 lastno = (Convert.ToInt64(split[1])) + 1;
ids = "JDISP-" + lastno.ToString("00000");
}
}
else
{
ids = "JDISP-00001";
}
}
else
{
if (result.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
string value = row["dispachno"].ToString();
string[] split = Regex.Split(value, "-");
Int64 lastno = (Convert.ToInt64(split[1])) + 1;
ids = "DISP-" + lastno.ToString("00000");
}
}
else
{
ids = "DISP-00001";
}
}
return(Json(ids, JsonRequestBehavior.AllowGet));
}
public JsonResult Getpaggingjson(string spname, int pq_curPage, int pq_rPP, string action = "select")
{
DataTable dt1 = DataOpration.GetDataTable(spname, new SqlParameter("@Action", "select"));
DataTable sm = DataOpration.GetDataTable(spname, new SqlParameter("@Action", "selectpageing"), new SqlParameter("@currentpage", pq_curPage), new SqlParameter("@recordperpage", pq_rPP));
Dictionary <string, object> rjson = new Dictionary <string, object>();
rjson.Add("totalRecords", dt1.Rows.Count);
rjson.Add("curPage", pq_curPage);
rjson.Add("data", DataOpration.DataTableTojsonstring(sm));
return(Json(rjson, JsonRequestBehavior.AllowGet));
//string sm = DataOpration.GetJsonData("GoodsInward_sp", new SqlParameter("@Action", "selectpageing"), new SqlParameter("@currentpage", pq_curPage), new SqlParameter("@recordperpage", pq_rPP));
//StringBuilder sb = new StringBuilder(@"{""totalRecords"":" + dt1.Rows.Count + @",""curPage"":" + pq_curPage + @",""data"":" + sm);
//JavaScriptSerializer js = new JavaScriptSerializer();
//sb.Append("}");
// return this.Content(sb.ToString(), "text/text");
}
