public Dictionary <string, object> ResetCampaign(Campaign Record) { Dictionary <string, object> RetData = new Dictionary <string, object>(); Boolean retvalue = false; int iTot = 0; try { google_uploader g = new google_uploader(); g.bSingle = false; g.user_is_admin = Record.user_is_admin; g.comp_code = Record._globalvariables.comp_code; g.user_id = Record._globalvariables.user_pkid; string str = g.Process(Record.cam_table_name, "name"); if (str != "") { g.ResetCampaign("doc_" + Record.cam_slno.ToString()); } iTot = g.iTot; } catch (Exception Ex) { retvalue = false; throw Ex; } RetData.Add("total", iTot); RetData.Add("retvalue", retvalue); return(RetData); }
public Dictionary <string, object> Save(pim_docm Record, tablesd [] Records, string ServerImageUrl) { DataTable Dt_Tablesm = new DataTable(); Dictionary <string, object> RetData = new Dictionary <string, object>(); string ErrorMessage = ""; Boolean retvalue = false; DBRecord Rec = null; Boolean is_campaign_table = false; int iSlno = 0; try { Con_Oracle = new DBConnection(); sql = "select * from tablesm where rec_company_code = '" + Record._globalvariables.comp_code + "' and tab_table_name = '" + Record.doc_table_name + "'"; Dt_Tablesm = Con_Oracle.ExecuteQuery(sql); if (Dt_Tablesm.Rows.Count > 0) { is_campaign_table = (Dt_Tablesm.Rows[0]["tab_campaign_table"].ToString() == "Y") ? true : false; } if (Dt_Tablesm.Rows.Count <= 0) { Lib.AddError(ref ErrorMessage, "Entity Not Found"); } //if (Record.doc_name.Trim().Length <= 0) // Lib.AddError(ref ErrorMessage, "name Cannot Be Empty"); if (ErrorMessage != "") { throw new Exception(ErrorMessage); } if ((ErrorMessage = AllValid(Record, Dt_Tablesm.Rows[0])) != "") { throw new Exception(ErrorMessage); } if (Record.rec_mode == "ADD") { sql = "select nvl(max(doc_slno), 1000) + 1 as slno from pim_docm "; if (Con_Oracle.DB == "SQL") { sql = "select isnull(max(doc_slno), 1000) + 1 as slno from pim_docm "; } sql += " where rec_company_code = '" + Record._globalvariables.comp_code + "' and doc_table_name ='" + Record.doc_table_name + "'"; //sql += " and doc_table_name = '" + Record.doc_table_name + "'"; iSlno = Lib.Conv2Integer(Con_Oracle.ExecuteScalar(sql).ToString()); Record.doc_slno = iSlno; if (iSlno <= 0) { throw new Exception("Invalid SL#"); } } else { iSlno = Record.doc_slno; } sql = ""; string sql1 = ""; Rec = new DBRecord(); Rec.CreateRow("pim_docm", Record.rec_mode, "doc_pkid", Record.doc_pkid); Rec.InsertString("doc_name", Record.doc_name, "P"); Rec.InsertString("doc_file_name", Record.doc_file_name, "P"); Rec.InsertString("doc_store_id", Record.doc_store_id); Rec.InsertString("doc_grp_id", Record.doc_grp_id); if (Record.doc_file_name.Trim().Trim().Length <= 0) { Rec.InsertString("doc_thumbnail", ""); } if (Record.rec_mode == "ADD") { Rec.InsertString("doc_slno", Record.doc_slno.ToString()); Rec.InsertString("doc_table_name", Record.doc_table_name); Rec.InsertString("rec_company_code", Record._globalvariables.comp_code); Rec.InsertString("rec_created_by", Record._globalvariables.user_code); if (Con_Oracle.DB == "ORACLE") { Rec.InsertFunction("rec_created_date", "SYSDATE"); } else { Rec.InsertFunction("rec_created_date", "GETDATE()"); } } if (Record.rec_mode == "EDIT") { Rec.InsertString("rec_edited_by", Record._globalvariables.user_code); if (Con_Oracle.DB == "ORACLE") { Rec.InsertFunction("rec_edited_date", "SYSDATE"); } else { Rec.InsertFunction("rec_edited_date", "GETDATE()"); } } sql = Rec.UpdateRow(); Rec = new DBRecord(); Rec.CreateRow(Record.doc_table_name, Record.rec_mode, "doc_parent_id", Record.doc_pkid); foreach (tablesd mRow in Records) { if (mRow.tabd_col_type == "DATE") { Rec.InsertDate("COL_" + mRow.tabd_col_name, mRow.tabd_col_value); } else if (mRow.tabd_col_type == "LIST") { Rec.InsertString("COL_" + mRow.tabd_col_name, mRow.tabd_col_id, "P"); } else { Rec.InsertString("COL_" + mRow.tabd_col_name, mRow.tabd_col_value, "P"); } } if (Record.rec_mode == "ADD") { Rec.InsertString("rec_company_code", Record._globalvariables.comp_code); Rec.InsertString("rec_created_by", Record._globalvariables.user_code); if (Con_Oracle.DB == "ORACLE") { Rec.InsertFunction("rec_created_date", "SYSDATE"); } else { Rec.InsertFunction("rec_created_date", "GETDATE()"); } } if (Record.rec_mode == "EDIT") { Rec.InsertString("rec_edited_by", Record._globalvariables.user_code); if (Con_Oracle.DB == "ORACLE") { Rec.InsertFunction("rec_edited_date", "SYSDATE"); } else { Rec.InsertFunction("rec_edited_date", "GETDATE()"); } } sql1 = Rec.UpdateRow(); Con_Oracle.BeginTransaction(); Con_Oracle.ExecuteNonQuery(sql); Con_Oracle.ExecuteNonQuery(sql1); Con_Oracle.CommitTransaction(); Con_Oracle.CloseConnection(); try { if (is_campaign_table == false) { google_uploader g = new google_uploader(); g.bSingle = true; g.comp_code = Record._globalvariables.comp_code; g.user_id = Record._globalvariables.user_pkid; string str = g.Process(Record.doc_table_name, "name"); if (str != "") { g.UploadData(Record.doc_pkid); } } } catch (Exception) { } retvalue = true; } catch (Exception Ex) { if (Con_Oracle != null) { Con_Oracle.RollbackTransaction(); Con_Oracle.CloseConnection(); } retvalue = false; throw Ex; } Con_Oracle.CloseConnection(); RetData.Add("retvalue", retvalue); RetData.Add("slno", iSlno); string server = Lib.getPath(ServerImageUrl, Record._globalvariables.comp_code, Record.doc_table_name, Record.doc_slno.ToString(), false); RetData.Add("server", server); RetData.Add("thumbnail", Record.doc_thumbnail); return(RetData); }