public JsonResult GetAmalkardTolid(string yearid)
{
var serviceResult = new ReportInfrastructure.Service.ServiceResult <IEnumerable <AmalkardTolid_ViewModel> >();
//AccountMoeein_FindModel MoeinAccount_FindModel = new AccountMoeein_FindModel ();
try
{
var model = DapperHelper.GetQueryResult <dynamic, AmalkardTolid_ViewModel>(new { YearID = yearid }, System.Data.CommandType.StoredProcedure, "[Acc].[Get_Amalkard_Tolid]");
serviceResult.SetData(model);
}
catch (Exception ex)
{
//serviceResult.SetException(new Exception(Alyatim.Localization.Resources.ActionMessages.UnknownError));
}
return(Json(serviceResult));
}
public JsonResult GetbahayeTamamshodeKala_2(string fromDate, string toDate, string yearid)
{
var fdate = "";
var tDate = "";
try
{
if (fromDate != "null")
{
fdate = fromDate.Substring(0, 4) + "/" + fromDate.Substring(5, 2) + "/" + fromDate.Substring(8, 2);
}
else
{
fdate = null;
}
if (toDate != "null")
{
tDate = toDate.Substring(0, 4) + "/" + toDate.Substring(5, 2) + "/" + toDate.Substring(8, 2);
}
else
{
tDate = null;
}
}
catch (Exception ex)
{
}
var serviceResult = new ReportInfrastructure.Service.ServiceResult <IEnumerable <BahayeTamamShode2_ViewModel> >();
//AccountMoeein_FindModel MoeinAccount_FindModel = new AccountMoeein_FindModel ();
try
{
var model = DapperHelper.GetQueryResult <dynamic, BahayeTamamShode2_ViewModel>(new { FromDate = fdate, ToDate = tDate, YearID = yearid }, System.Data.CommandType.StoredProcedure, "[Acc].[Get_BahayTamashode_KalayeForoshRafte_2]");
serviceResult.SetData(model);
}
catch (Exception ex)
{
//serviceResult.SetException(new Exception(Alyatim.Localization.Resources.ActionMessages.UnknownError));
}
return(Json(serviceResult));
}
public JsonResult Add([FromBody] test_InputModel model)
{
var serviceResult = new ReportInfrastructure.Service.ServiceResult <bool>();
try
{
if (!ModelState.IsValid)
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.NotValid;
serviceResult.SetException(new Exception("Validation Error"));
return(Json(serviceResult));
}
var result = MainDapperHelper.ExecuteQuery_With_DataAndMessage <bool, DBMessageModel>("[dbo].[ins_test]", model, System.Data.CommandType.StoredProcedure, ReturnType.MessageAndData);
serviceResult.SetData(result?.data?.FirstOrDefault() ?? true);
serviceResult.Message = result.message?.Value;
}
catch (SqlException ex)
{
if (ex.Number == ReportInfrastructure.Sql.ErrorNumbers.CustomErrors)
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.Exception;
serviceResult.Message = ex.Message;
}
else
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.Exception;
serviceResult.SetException(new Exception("UnknownError"));
}
}
catch (Exception ex)
{
serviceResult.SetException(new Exception("UnknownError"));
}
return(Json(serviceResult));
}
public static ReportInfrastructure.Service.ServiceResult <int> DeleteMultipleItems(int[] ID, string storedProcedureName /*string token, string ip, string culture, int branchID*/)
{
var serviceResult = new ReportInfrastructure.Service.ServiceResult <int>();
if (string.IsNullOrEmpty(storedProcedureName))
{
throw new Exception("Developer Exception ...");
}
if (ID == null)
{
serviceResult.State = Service.StateEnum.NotValid;
return(serviceResult);
}
var IDs = ID.Select(S => new IDModel <int> {
ID = S /*Token = token, IP = ip, Culture = culture, BranchID = branchID */
})?.ToArray();
bool isOK = IDs.Any(p => !(p.ID > 0));
if (isOK)
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.NotValid;
return(serviceResult);
}
try
{
using (IDbConnection conn = Connection)
{
if (!(conn.State == ConnectionState.Open))
{
conn.Open();
}
//T[] inputModel
var result = DapperHelper.ExecuteMultiple <IDModel <int> >(IDs, System.Data.CommandType.StoredProcedure, storedProcedureName);
serviceResult.SetData(result);
//object param = new { IDs/*, token */};
//var result = conn.Execute(storedProcedureName, param, commandType: CommandType.StoredProcedure);
//serviceResult.SetData(result);
}
//var result = DapperHelper.ExecuteMultiple<IDModel<int>>(IDs, System.Data.CommandType.StoredProcedure, storedProcedureName);
//serviceResult.SetData(result);
}
catch (SqlException ex)
{
if (ex.Number == ReportInfrastructure.Sql.ErrorNumbers.CustomErrors)
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.Exception;
serviceResult.Message = ex.Message;
}
else
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.Exception;
//serviceResult.Message = ex.Message;
}
}
catch (Exception ex)
{
serviceResult.State = ReportInfrastructure.Service.StateEnum.Exception;
}
return(serviceResult);
}
