Ejemplo n.º 1
0
        public OutPut ExecuteMethod(JObject Model, Enums.Enum.Method method)
        {
            OutPut            op      = new OutPut();
            DynamicParameters spParam = new DynamicParameters();

            using (IDbConnection conn = Connection)
            {
                try
                {
                    //validasi
                    if (Model.Count == 0)
                    {
                        op.Error   = true;
                        op.Message = "Data Not Valid";
                        return(op);
                    }
                    if (Model["ApiName"] == null)
                    {
                        op.Error   = true;
                        op.Message = "No Parameter ApiName!";
                        return(op);
                    }
                    string ApiName = Model["ApiName"].ToString();
                    MvSpName = (from opt in optRepo.GetList(method.ToString(), ApiName)
                                select opt.Functions).FirstOrDefault();

                    if (string.IsNullOrEmpty(MvSpName))
                    {
                        op.Error   = true;
                        op.Message = "Please Contact Your Administrator (Table setting null or Empty)";
                        return(op);
                    }
                    Model.Remove("ApiName");
                    conn.Open();

                    if (method == Enums.Enum.Method.GetDataBy)
                    {
                        string sSortField   = Model["SortField"] == null || string.IsNullOrEmpty(Model["SortField"].ToString()) ? string.Empty : "ORDER BY " + Model["SortField"].ToString();
                        string sParameter   = Model["InitialWhere"] == null || string.IsNullOrEmpty(Model["InitialWhere"].ToString()) ? string.Empty : "WHERE " + Model["InitialWhere"].ToString();
                        var    affectedRows = this.Query(MvSpName, sParameter, sSortField);
                        op.Data = affectedRows;
                    }
                    else
                    {
                        spParam = fn.SpParameters(Model, MvSpName);
                        var affectedRows = conn.Query(MvSpName, spParam, commandType: CommandType.StoredProcedure);
                        op.Data = affectedRows;
                    }


                    //op.Message = "";
                    if (method == Enums.Enum.Method.Delete || method == Enums.Enum.Method.Update)
                    {
                        op.Message = "Data Has Been " + method.ToString() + "d Successfully";
                    }
                    else if (method == Enums.Enum.Method.Insert)
                    {
                        op.Message = "Data Has Been " + method.ToString() + "ed Successfully";
                    }
                }
                catch (Exception ex)
                {
                    fn.InsetErrorLog("Error " + method.ToString(), ex.Message + ex.StackTrace);
                    op.Error   = true;
                    op.Message = ex.Message;
                }
                finally
                {
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }

            return(op);
        }
Ejemplo n.º 2
0
        public OutPutList <dynamic> GetList(JObject Model, Enums.Enum.Method method)
        {
            var op = new OutPutList <dynamic>();
            DynamicParameters spParam = new DynamicParameters();

            using (IDbConnection conn = Connection)
            {
                try
                {
                    //validasi
                    if (Model.Count == 0)
                    {
                        op.Error   = true;
                        op.Message = "Data Not Valid";
                        return(op);
                    }
                    if (Model["ApiName"] == null)
                    {
                        op.Error   = true;
                        op.Message = "No Parameter ApiName!";
                        return(op);
                    }
                    string ApiName = Model["ApiName"].ToString();
                    MvSpName = (from opt in optRepo.GetList(method.ToString(), ApiName)
                                select opt.Functions).FirstOrDefault();

                    if (string.IsNullOrEmpty(MvSpName))
                    {
                        op.Error   = true;
                        op.Message = "Please Contact Your Administrator (Table setting null or Empty)";
                        return(op);
                    }
                    //Model.Remove("ApiName");
                    conn.Open();
                    int    iStart     = Convert.ToInt32(Model["CurrentPage"]);
                    int    iPerPage   = Convert.ToInt32(Model["PerPage"]);
                    string sSortField = string.IsNullOrEmpty(Model["SortField"].ToString()) ? string.Empty : "ORDER BY " + Model["SortField"].ToString();
                    //string sSearchField = Model["SearchField"].ToString();
                    string sParamWhere = Model["ParamWhere"].ToString();
                    string sParameter  = string.Empty;
                    //InitialWhere
                    //ParamWhere
                    if (!string.IsNullOrEmpty(Model["InitialWhere"].ToString()))
                    {
                        sParameter += "WHERE " + Model["InitialWhere"].ToString();
                    }
                    if (!string.IsNullOrEmpty(sParamWhere))
                    {
                        string sWhereLike = fn.sWhereLikeList(MvSpName, sParamWhere);
                        sParameter += !string.IsNullOrEmpty(sWhereLike) ? " AND " + sWhereLike : sParameter;
                        //if (!string.IsNullOrEmpty(sSearchField))
                        //{
                        //    string[] sField = sSearchField.Split(",");
                        //    string sParam = string.Empty;
                        //    foreach (var field in sField)
                        //    {
                        //        sParam += string.Format("lower({0}) LIKE '%{1}%' OR ", field, sParamWhere.ToLower());
                        //    }
                        //    sParam = !string.IsNullOrEmpty(sParam) ? sParam.Remove(sParam.LastIndexOf("OR")) : sParam;
                        //    sParameter = string.IsNullOrEmpty(sParameter) ? "WHERE " + sParam : " AND " + sParam;
                        //}
                        //else
                        //{
                        //    op.Error = true;
                        //    op.Message = "Parameter SearchField can't be null";
                        //    return op;
                        //}
                    }
                    //var affectedRows = conn.Query(MvSpName, spParam, commandType: CommandType.StoredProcedure);
                    op.Data         = this.QueryList(MvSpName, iStart, iPerPage, sSortField, sParameter);
                    op.Total        = Convert.ToInt32(this.CountList(MvSpName, sParameter));
                    op.Current_Page = iStart;
                    op.Last_Page    = Convert.ToInt32(Math.Ceiling((Convert.ToDecimal(op.Total) / iPerPage)));
                }
                catch (Exception ex)
                {
                    fn.InsetErrorLog("Error " + method.ToString(), ex.Message + ex.StackTrace);
                    op.Error   = true;
                    op.Message = ex.Message;
                }
                finally
                {
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }

            return(op);
        }