Пример #1
0
        public jsonResponse Delete(Int32 id, string DataObject, string Ext)
        {
            jsonResponse JsonResp = new jsonResponse { ErrorMsg = "", ResponseMsg = "" };
             SqlConnection con = new SqlConnection(conStr);
             SqlCommand cmd = new SqlCommand("proc_Update_Delete", con);
             cmd.CommandType = System.Data.CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@TableName", DataObject.Trim());
             cmd.Parameters.AddWithValue("@ID", id);
             cmd.Parameters.AddWithValue("@UserID", UserData.UserID);

             SqlParameter Extout = cmd.Parameters.AddWithValue("@Ext", ((Ext == null) ? "" : Ext));
             Extout.SqlDbType = System.Data.SqlDbType.NVarChar;
             Extout.Size = -1;
             Extout.Direction = ParameterDirection.InputOutput;

             //SqlParameter SuccessMsg = cmd.Parameters.AddWithValue("@SuccessMsg", "");
             //SuccessMsg.SqlDbType = System.Data.SqlDbType.NVarChar;
             //SuccessMsg.Size = -1;
             //SuccessMsg.Direction = ParameterDirection.InputOutput;

             cmd.Parameters.AddWithValue("@AccountID", UserData.AccountID);

             try {
            con.Open(); cmd.ExecuteNonQuery(); { JsonResp.ResponseMsg = new { Ext = ((Extout.Value != null) ? Convert.ToString(Extout.Value) : "") }; }
            //con.Open(); cmd.ExecuteNonQuery(); { JsonResp.ResponseMsg = new { SuccessMsg = ((SuccessMsg.Value != null) ? Convert.ToString(SuccessMsg.Value) : ""), Ext = ((Extout.Value != null) ? Convert.ToString(Extout.Value) : "") }; }
             }
             catch (Exception ex) { JsonResp.ErrorMsg = ex.Message; }
             finally { con.Close(); }
             return JsonResp;
        }
Пример #2
0
        public jsonResponse AddNew(string[] Data, string[] Fields, string DataObject, string Ext)
        {
            jsonResponse JsonResp = new jsonResponse { ErrorMsg = "", ResponseMsg = "" };
             SqlConnection con = new SqlConnection(conStr);
             SqlCommand cmd = new SqlCommand("proc_Update_AddNew", con);
             cmd.CommandType = System.Data.CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@TableName", DataObject.Trim());
             cmd.Parameters.AddWithValue("@Data", GetStringFromArrSpec(Data));//Spec duomenu delimiteris, nes ten kbl gali but
             cmd.Parameters.AddWithValue("@Fields", GetStringFromArrComma(Fields));

             SqlParameter Extout = cmd.Parameters.AddWithValue("@Ext", ((Ext == null) ? "" : Ext));
             Extout.SqlDbType = System.Data.SqlDbType.NVarChar;
             Extout.Size = -1;
             Extout.Direction = ParameterDirection.InputOutput;

             SqlParameter IDout = cmd.Parameters.AddWithValue("@ID", 0);
             IDout.Direction = ParameterDirection.InputOutput;

             cmd.Parameters.AddWithValue("@UserID", UserData.UserID);
             cmd.Parameters.AddWithValue("@AccountID", UserData.AccountID);

             try {
            con.Open(); cmd.ExecuteNonQuery(); Int32 ID = Convert.ToInt32(IDout.Value);
            JsonResp.ResponseMsg = new { ID = ID, Ext = ((Extout.Value != null) ? Convert.ToString(Extout.Value) : "") };
             }
             catch (Exception ex) { JsonResp.ErrorMsg = ex.Message; }
             finally { con.Close(); }
             return JsonResp;
        }