public Dictionary <string, object> SaveStatus(pim_spotd Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            Boolean retvalue = false;

            try
            {
                Con_Oracle = new DBConnection();
                DBRecord Rec = new DBRecord();
                Rec.CreateRow("pim_spotd", "EDIT", "spotd_pkid", Record.spotd_pkid);
                Rec.InsertString("spotd_status", Record.spotd_status);
                sql = Rec.UpdateRow();
                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                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);

            return(RetData);
        }
        public Dictionary <string, object> Save(Modulem Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string ErrorMessage = "";

            try
            {
                Con_Oracle = new DBConnection();

                if (Record.module_name.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Name Cannot Be Empty");
                }

                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if ((ErrorMessage = AllValid(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }


                DBRecord Rec = new DBRecord();
                Rec.CreateRow("modulem", Record.rec_mode, "module_pkid", Record.module_pkid);
                Rec.InsertString("module_name", Record.module_name, "Z");
                Rec.InsertNumeric("module_order", Record.module_order.ToString());

                if (Record.rec_mode == "ADD")
                {
                    Rec.InsertString("rec_company_code", Record._globalvariables.comp_code);
                }


                sql = Rec.UpdateRow();


                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
            }
            catch (Exception Ex)
            {
                if (Con_Oracle != null)
                {
                    Con_Oracle.RollbackTransaction();
                    Con_Oracle.CloseConnection();
                }
                throw Ex;
            }
            Con_Oracle.CloseConnection();
            return(RetData);
        }
Ejemplo n.º 3
0
        public Dictionary <string, object> Save(paramvalues_vm Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();

            try
            {
                Con_Oracle = new DBConnection();

                DBRecord Rec = new DBRecord();

                Con_Oracle.BeginTransaction();

                sql = "delete from paramvalues where parent_id ='" + Record.param_pkid + "'";
                Con_Oracle.ExecuteNonQuery(sql);

                foreach (paramvalues _Record in Record.RecordDet)
                {
                    if (_Record.param_value.ToString().Length > 0)
                    {
                        _Record.param_pkid = System.Guid.NewGuid().ToString().ToUpper();
                        Rec.CreateRow("paramvalues", "ADD", "param_pkid", _Record.param_pkid);
                        Rec.InsertString("parent_id", Record.param_pkid);
                        Rec.InsertString("param_key", _Record.param_key);
                        Rec.InsertString("param_value", _Record.param_value, "P");

                        Rec.InsertString("param_filetype", _Record.param_filetype);
                        Rec.InsertString("param_impexp", _Record.param_impexp);
                        Rec.InsertString("param_edifile", _Record.param_edifile);

                        Rec.InsertString("param_format", _Record.param_format);

                        Rec.InsertString("rec_company_code", Record._globalvariables.comp_code);
                        sql = Rec.UpdateRow();
                        Con_Oracle.ExecuteNonQuery(sql);
                    }
                }
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
            }
            catch (Exception Ex)
            {
                if (Con_Oracle != null)
                {
                    Con_Oracle.RollbackTransaction();
                    Con_Oracle.CloseConnection();
                }
                throw Ex;
            }
            Con_Oracle.CloseConnection();
            return(RetData);
        }
        public Dictionary <string, object> Save_recce_user(pim_spot Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string  ErrorMessage = "";
            Boolean retvalue     = false;

            try
            {
                Con_Oracle = new DBConnection();

                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                DBRecord Rec = new DBRecord();
                Rec.CreateRow("pim_spotm", "EDIT", "spot_pkid", Record.spot_pkid);
                Rec.InsertString("spot_recce_id", Record.spot_recce_id);

                sql = Rec.UpdateRow();

                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                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);

            return(RetData);
        }
        public Dictionary <string, object> Save(Campaign Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string ErrorMessage = "";

            try
            {
                Con_Oracle = new DBConnection();

                if (Record.cam_name.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Name Cannot Be Empty");
                }

                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if ((ErrorMessage = AllValid(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }


                DBRecord Rec = new DBRecord();

                Rec.CreateRow("campaign", Record.rec_mode, "cam_pkid", Record.cam_pkid);
                Rec.InsertString("cam_name", Record.cam_name);
                Rec.InsertString("cam_tab_id", Record.cam_tab_id);
                Rec.InsertString("cam_store", Record.cam_store, "Z");
                Rec.InsertString("cam_product_name", Record.cam_product_name, "Z");
                Rec.InsertString("cam_product_name_values", Record.cam_product_name_values, "Z");
                Rec.InsertString("cam_size", Record.cam_size, "Z");
                Rec.InsertString("cam_size_values", Record.cam_size_values, "Z");
                Rec.InsertString("cam_aep", Record.cam_aep, "Z");
                Rec.InsertString("cam_aep_values", Record.cam_aep_values, "Z");
                Rec.InsertString("cam_output", Record.cam_output, "Z");
                Rec.InsertString("cam_output_values", Record.cam_output_values, "Z");
                Rec.InsertString("cam_approver", Record.cam_approver, "Z");
                Rec.InsertString("cam_receiver", Record.cam_receiver, "Z");
                Rec.InsertString("cam_logo", Record.cam_logo, "Z");
                Rec.InsertString("cam_image1", Record.cam_image1, "Z");
                Rec.InsertString("cam_image2", Record.cam_image2, "Z");
                Rec.InsertString("cam_image3", Record.cam_image3, "Z");
                Rec.InsertString("cam_image4", Record.cam_image4, "Z");
                Rec.InsertString("cam_image5", Record.cam_image5, "Z");
                Rec.InsertString("cam_text1", Record.cam_text1, "Z");
                Rec.InsertString("cam_text1_values", Record.cam_text1_values, "Z");
                Rec.InsertString("cam_text2", Record.cam_text2, "Z");
                Rec.InsertString("cam_text2_values", Record.cam_text2_values, "Z");
                Rec.InsertString("cam_text3", Record.cam_text3, "Z");
                Rec.InsertString("cam_text3_values", Record.cam_text3_values, "Z");
                Rec.InsertString("cam_text4", Record.cam_text4, "Z");
                Rec.InsertString("cam_text4_values", Record.cam_text4_values, "Z");
                Rec.InsertString("cam_text5", Record.cam_text5, "Z");
                Rec.InsertString("cam_text5_values", Record.cam_text5_values, "Z");

                if (Record.rec_mode == "ADD")
                {
                    Rec.InsertString("rec_company_code", Record._globalvariables.comp_code);
                    Rec.InsertString("rec_created_by", Record._globalvariables.user_code);
                    Rec.InsertFunction("rec_created_date", "GETDATE()");
                }
                if (Record.rec_mode == "EDIT")
                {
                    Rec.InsertString("rec_edited_by", Record._globalvariables.user_code);
                    Rec.InsertFunction("rec_edited_date", "GETDATE()");
                }

                sql = Rec.UpdateRow();

                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
            }
            catch (Exception Ex)
            {
                if (Con_Oracle != null)
                {
                    Con_Oracle.RollbackTransaction();
                    Con_Oracle.CloseConnection();
                }
                throw Ex;
            }
            Con_Oracle.CloseConnection();
            return(RetData);
        }
Ejemplo n.º 6
0
        public Dictionary <string, object> Save(pim_groupm Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string  ErrorMessage = "";
            Boolean retvalue     = false;

            DataTable dt_parent = null;


            try
            {
                Con_Oracle = new DBConnection();

                if (Record.grp_name.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "name Cannot Be Empty");
                }

                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if ((ErrorMessage = AllValid(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }


                if (Record.rec_type == "ROOT")
                {
                    Record.grp_level     = 1;
                    Record.grp_parent_id = "";
                }
                else
                {
                    sql       = "select * from pim_groupm where grp_pkid = '" + Record.grp_parent_id + "'";
                    dt_parent = Con_Oracle.ExecuteQuery(sql);
                    if (dt_parent.Rows.Count <= 0)
                    {
                        if (ErrorMessage != "")
                        {
                            throw new Exception("Invalid Parent");
                        }
                    }
                    Record.grp_level     = Lib.Conv2Integer(dt_parent.Rows[0]["grp_level"].ToString()) + 1;
                    Record.grp_parent_id = dt_parent.Rows[0]["grp_pkid"].ToString();
                }

                if (Record.grp_level <= 0)
                {
                    throw new Exception("Invalid group level");
                }

                sql  = "select max(grp_name) as grp_name from pim_groupm where ";
                sql += " rec_company_code = '" + Record._globalvariables.comp_code + "'";
                sql += " and grp_name = '" + Record.grp_name.ToString().ToLower() + "'";
                sql += " and grp_table_name = '" + Record.grp_table_name.ToString().ToLower() + "'";

                if (Record.grp_parent_id == "")
                {
                    sql += " and grp_parent_id is null ";
                }
                else
                {
                    sql += " and grp_parent_id = '" + Record.grp_parent_id + "'";
                }

                if (Con_Oracle.IsRowExists(sql))
                {
                    throw new Exception("Dupliate name not  allowed ");
                }



                sql = "select nvl(max(grp_level_slno), 100000) + 1  as slno from pim_groupm where ";

                if (Con_Oracle.DB == "SQL")
                {
                    sql = "select isnull(max(grp_level_slno), 100000) + 1  as slno from pim_groupm where ";
                }

                sql += " rec_company_code = '" + Record._globalvariables.comp_code + "'";
                sql += " and grp_table_name = '" + Record.grp_table_name + "'";
                if (Record.grp_parent_id == "")
                {
                    sql += " and grp_parent_id is null ";
                }
                else
                {
                    sql += " and grp_parent_id = '" + Record.grp_parent_id + "'";
                }

                int iSlno = Lib.Conv2Integer(Con_Oracle.ExecuteScalar(sql).ToString());

                if (iSlno <= 0)
                {
                    throw new Exception("Invalid SL#");
                }


                if (Record.rec_type == "ROOT")
                {
                    Record.grp_level_id   = iSlno.ToString();
                    Record.grp_level_name = Record.grp_name;
                }
                else
                {
                    Record.grp_level_id   = dt_parent.Rows[0]["grp_level_id"].ToString() + "-" + iSlno.ToString();
                    Record.grp_level_name = dt_parent.Rows[0]["grp_level_name"].ToString() + "\\" + Record.grp_name;
                }


                DBRecord Rec = new DBRecord();
                Rec.CreateRow("pim_groupm", Record.rec_mode, "grp_pkid", Record.grp_pkid);
                Rec.InsertString("grp_name", Record.grp_name, "L");

                Rec.InsertString("grp_parent_id", Record.grp_parent_id);
                Rec.InsertNumeric("grp_level", Record.grp_level.ToString());

                Rec.InsertString("grp_level_slno", iSlno.ToString());
                Rec.InsertString("grp_level_id", Record.grp_level_id);
                Rec.InsertString("grp_level_name", Record.grp_level_name, "L");

                if (Record.rec_mode == "ADD")
                {
                    Rec.InsertString("grp_table_name", Record.grp_table_name);
                    Rec.InsertString("rec_company_code", Record._globalvariables.comp_code);
                    Rec.InsertString("rec_hidden", "N");
                    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();

                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                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("grp_level_id", Record.grp_level_id);
            RetData.Add("grp_level_name", Record.grp_level_name);

            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);
        }
        public Dictionary <string, object> Save(pim_spot Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string  ErrorMessage = "";
            Boolean retvalue     = false;

            int iSlno = 0;

            try
            {
                Con_Oracle = new DBConnection();

                if (Record.spot_date.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Date Cannot Be Empty");
                }

                if (Record.spot_store_id.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Store Cannot Be Empty");
                }

                if (Record.spot_vendor_id.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Vendor Cannot Be Empty");
                }


                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if ((ErrorMessage = AllValid(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }


                if (Record.rec_mode == "ADD")
                {
                    sql   = "select isnull(max(spot_slno), 1) + 1  as slno from pim_spotm where ";
                    sql  += " rec_company_code = '" + Record._globalvariables.comp_code + "'";
                    iSlno = Lib.Conv2Integer(Con_Oracle.ExecuteScalar(sql).ToString());
                }
                else
                {
                    iSlno = Record.spot_slno;
                }

                if (iSlno <= 0)
                {
                    throw new Exception("Invalid CF#");
                }


                DBRecord Rec = new DBRecord();
                Rec.CreateRow("pim_spotm", Record.rec_mode, "spot_pkid", Record.spot_pkid);
                Rec.InsertDate("spot_date", Record.spot_date);
                Rec.InsertString("spot_store_id", Record.spot_store_id);

                Rec.InsertString("spot_vendor_id", Record.spot_vendor_id);

                Rec.InsertString("spot_job_remarks", Record.spot_job_remarks);


                if (Record.rec_mode == "ADD")
                {
                    Rec.InsertNumeric("spot_slno", iSlno.ToString());
                    Rec.InsertString("spot_executive_name", Record._globalvariables.user_name);

                    Rec.InsertString("spot_store_contact_name", Record.spot_store_contact_name);
                    Rec.InsertString("spot_store_contact_tel", Record.spot_store_contact_tel);

                    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();

                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                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);

            return(RetData);
        }
        public Dictionary <string, object> SaveDet(pim_spotd Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string  ErrorMessage = "";
            Boolean retvalue     = false;

            DataTable dt_param = null;

            int iSlno = 0;

            try
            {
                Con_Oracle = new DBConnection();


                if (Record.spotd_name.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Spot Name Cannot Be Empty");
                }
                if (Record.spotd_uom.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Unit Cannot Be Empty");
                }
                if (Lib.Conv2Decimal(Record.spotd_wd.ToString()) <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Width Cannot Be Empty");
                }
                if (Lib.Conv2Decimal(Record.spotd_ht.ToString()) <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Height Cannot Be Empty");
                }
                if (Record.spotd_artwork_id.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "ArtWork Cannot Be Empty");
                }
                if (Record.spotd_product_id.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Product Cannot Be Empty");
                }


                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if ((ErrorMessage = AllValidDet(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }

                //sql = " select param_slno,param_file_name from param where param_pkid = '" + Record.spot_artwork_id + "'";
                //dt_param = Con_Oracle.ExecuteQuery(sql);

                if (Record.rec_mode == "ADD")
                {
                    sql   = "select isnull(max(spotd_slno), 0) + 1  as slno from pim_spotd where ";
                    sql  += " spotd_parent_id = '" + Record.spotd_parent_id + "'";
                    iSlno = Lib.Conv2Integer(Con_Oracle.ExecuteScalar(sql).ToString());
                }
                else
                {
                    iSlno = Record.spotd_slno;
                }

                if (iSlno <= 0)
                {
                    throw new Exception("Invalid SL#");
                }


                DBRecord Rec = new DBRecord();
                Rec.CreateRow("pim_spotd", Record.rec_mode, "spotd_pkid", Record.spotd_pkid);
                Rec.InsertString("spotd_name", Record.spotd_name);
                Rec.InsertString("spotd_uom", Record.spotd_uom);
                Rec.InsertNumeric("spotd_wd", Record.spotd_wd.ToString());
                Rec.InsertNumeric("spotd_ht", Record.spotd_ht.ToString());
                Rec.InsertString("spotd_artwork_id", Record.spotd_artwork_id);
                Rec.InsertString("spotd_product_id", Record.spotd_product_id);
                Rec.InsertString("spotd_close_view", Record.spotd_close_view);
                Rec.InsertString("spotd_long_view", Record.spotd_long_view);
                Rec.InsertString("spotd_final_view", Record.spotd_final_view);

                if (Record.rec_mode == "ADD")
                {
                    Rec.InsertString("spotd_parent_id", Record.spotd_parent_id);
                    Rec.InsertNumeric("spotd_slno", iSlno.ToString());
                    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();

                Con_Oracle.BeginTransaction();
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                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);

            return(RetData);
        }
        public IDictionary <string, object> CopyRights(UserRights_VM VM)
        {
            string USERID       = "";
            string BRANCHID     = "";
            string MENUID       = "";
            string ErrorMessage = "";
            string sMode        = "ADD";

            Dictionary <string, object> RetData = new Dictionary <string, object>();
            DataTable Dt_Menu = new DataTable();

            DataTable Dt_Rec = new DataTable();

            DBRecord mRec;

            Con_Oracle = new DBConnection();

            GlobalVariables mGbl            = VM.globalVariables;
            string          COPYTO_USERID   = VM.copyto_user_id;
            string          COPYTO_BRANCHID = VM.copyto_branch_id;

            try
            {
                if (COPYTO_USERID.Length <= 0)
                {
                    ErrorMessage += "| Copy User ID Not Found";
                }

                DataTable Dt_Usrbranch = new DataTable();
                sql = "select user_branch_id from userd where user_id = '" + COPYTO_USERID + "'";
                if (COPYTO_BRANCHID.Trim() != "")
                {
                    sql += " and user_branch_id = '" + COPYTO_BRANCHID + "'";
                }

                Dt_Usrbranch = Con_Oracle.ExecuteQuery(sql);
                if (Dt_Usrbranch.Rows.Count <= 0)
                {
                    ErrorMessage += " | Branch Rights Not Found";
                }

                if (ErrorMessage != "")
                {
                    if (Con_Oracle != null)
                    {
                        Con_Oracle.CloseConnection();
                    }
                    throw new Exception(ErrorMessage);
                }

                foreach (DataRow dr in Dt_Usrbranch.Rows)
                {
                    COPYTO_BRANCHID = dr["user_branch_id"].ToString();

                    Con_Oracle.BeginTransaction();
                    foreach (var Rec in VM.userRights)
                    {
                        Rec.rights_id = Guid.NewGuid().ToString().ToUpper();
                        sMode         = "ADD";

                        USERID   = COPYTO_USERID;
                        BRANCHID = COPYTO_BRANCHID;
                        MENUID   = Rec.menu_id;

                        sql  = "";
                        sql += " select rights_pkid from userrights where ";
                        sql += " rights_user_id = '{USERID}'  and ";
                        sql += " rights_branch_id = '{BRANCHID}' and ";
                        sql += " rights_menu_id = '{MENUID}' ";

                        sql = sql.Replace("{USERID}", USERID);
                        sql = sql.Replace("{BRANCHID}", BRANCHID);
                        sql = sql.Replace("{MENUID}", MENUID);

                        Dt_Menu = new DataTable();
                        Dt_Menu = Con_Oracle.ExecuteQuery(sql);
                        if (Dt_Menu.Rows.Count > 0)
                        {
                            Rec.rights_id = Dt_Menu.Rows[0].ToString();
                            sMode         = "EDIT";
                        }

                        if (Rec.rights_company || Rec.rights_admin || Rec.rights_add || Rec.rights_edit ||
                            Rec.rights_delete || Rec.rights_print || Rec.rights_email || Rec.rights_docs ||
                            Rec.rights_view)
                        {
                            if (Rec.rights_add || Rec.rights_edit)
                            {
                                Rec.rights_view = true;
                            }

                            Rec.rights_branch_id = BRANCHID;
                            Rec.rights_user_id   = USERID;

                            mRec = new DBRecord();
                            mRec.CreateRow("userrights", sMode, "rights_pkid", Rec.rights_id.ToString());
                            mRec.InsertString("rights_branch_id", Rec.rights_branch_id.ToString());
                            mRec.InsertString("rights_user_id", Rec.rights_user_id.ToString());
                            mRec.InsertString("rights_menu_id", Rec.menu_id.ToString());
                            mRec.InsertString("rights_company", (Rec.rights_company) ? "Y" : "N");
                            mRec.InsertString("rights_admin", (Rec.rights_admin) ? "Y" : "N");
                            mRec.InsertString("rights_add", (Rec.rights_add) ? "Y" : "N");
                            mRec.InsertString("rights_edit", (Rec.rights_edit) ? "Y" : "N");
                            mRec.InsertString("rights_delete", (Rec.rights_delete) ? "Y" : "N");
                            mRec.InsertString("rights_print", (Rec.rights_print) ? "Y" : "N");
                            mRec.InsertString("rights_email", (Rec.rights_email) ? "Y" : "N");
                            mRec.InsertString("rights_docs", (Rec.rights_docs) ? "Y" : "N");
                            mRec.InsertString("rights_docs_upload", (Rec.rights_docs_upload) ? "Y" : "N");
                            mRec.InsertString("rights_view", (Rec.rights_view) ? "Y" : "N");
                            // mRec.InsertString("rights_approval", Rec.rights_approval);

                            Con_Oracle.ExecuteNonQuery(mRec.UpdateRow());
                        }
                    }

                    sql  = "";
                    sql  = " update userd set user_rights_total = (select count(*) from userrights where rights_user_id = '{USERID}' and rights_branch_id = '{BRANCHID}')";
                    sql += " where user_id = '{USERID}' and user_branch_id = '{BRANCHID}'";
                    sql  = sql.Replace("{USERID}", USERID);
                    sql  = sql.Replace("{BRANCHID}", BRANCHID);
                    Con_Oracle.ExecuteNonQuery(sql);

                    Con_Oracle.CommitTransaction();
                }
            }
            catch (Exception Ex)
            {
                if (Con_Oracle != null)
                {
                    Con_Oracle.RollbackTransaction();
                    Con_Oracle.CloseConnection();
                }
                throw Ex;
            }
            Con_Oracle.CloseConnection();
            return(RetData);
        }
        public IDictionary <string, object> Save(UserRights_VM VM)
        {
            string USERID   = "";
            string COMPID   = "";
            string BRANCHID = "";
            string MENUID   = "";

            Dictionary <string, object> RetData = new Dictionary <string, object>();

            DataTable Dt_Rec = new DataTable();
            DBRecord  mRec;

            Con_Oracle = new DBConnection();

            GlobalVariables mGbl = VM.globalVariables;

            try
            {
                Con_Oracle.BeginTransaction();
                foreach (var Rec in VM.userRights)
                {
                    USERID   = Rec.rights_user_id;
                    COMPID   = Rec.rights_company_id;
                    BRANCHID = Rec.rights_branch_id;
                    MENUID   = Rec.menu_id;

                    sql  = "";
                    sql += " delete from userrights where ";
                    sql += " rights_user_id = '{USERID}'  and ";
                    sql += " rights_company_id = '{COMPID}' and ";
                    sql += " rights_menu_id = '{MENUID}' ";

                    sql = sql.Replace("{USERID}", USERID);
                    sql = sql.Replace("{COMPID}", COMPID);
                    sql = sql.Replace("{MENUID}", MENUID);
                    Con_Oracle.ExecuteNonQuery(sql);


                    if (Rec.rights_company || Rec.rights_admin || Rec.rights_add || Rec.rights_edit ||
                        Rec.rights_delete || Rec.rights_print || Rec.rights_email || Rec.rights_docs ||
                        Rec.rights_view || Rec.rights_approval.Length > 0)
                    {
                        if (Rec.rights_add || Rec.rights_edit)
                        {
                            Rec.rights_view = true;
                        }

                        mRec = new DBRecord();
                        mRec.CreateRow("userrights", "ADD", "rights_pkid", Rec.rights_id.ToString());
                        mRec.InsertString("rights_company_id", Rec.rights_company_id.ToString());
                        //mRec.InsertString("rights_branch_id", Rec.rights_branch_id.ToString());
                        mRec.InsertString("rights_user_id", Rec.rights_user_id.ToString());
                        mRec.InsertString("rights_menu_id", Rec.menu_id.ToString());
                        mRec.InsertString("rights_company", (Rec.rights_company) ? "Y" : "N");
                        mRec.InsertString("rights_admin", (Rec.rights_admin) ? "Y" : "N");
                        mRec.InsertString("rights_add", (Rec.rights_add) ? "Y" : "N");
                        mRec.InsertString("rights_edit", (Rec.rights_edit) ? "Y" : "N");
                        mRec.InsertString("rights_delete", (Rec.rights_delete) ? "Y" : "N");
                        mRec.InsertString("rights_print", (Rec.rights_print) ? "Y" : "N");
                        mRec.InsertString("rights_email", (Rec.rights_email) ? "Y" : "N");
                        mRec.InsertString("rights_docs", (Rec.rights_docs) ? "Y" : "N");
                        mRec.InsertString("rights_docs_upload", (Rec.rights_docs_upload) ? "Y" : "N");
                        mRec.InsertString("rights_view", (Rec.rights_view) ? "Y" : "N");
                        mRec.InsertString("rights_restricted", (Rec.rights_restricted) ? "Y" : "N");
                        mRec.InsertString("rights_approval", Rec.rights_approval);

                        Con_Oracle.ExecuteNonQuery(mRec.UpdateRow());
                    }
                }


                /*
                 * sql = "";
                 * sql = " update userd set user_rights_total = (select count(*) from userrights where rights_user_id = '{USERID}' and rights_branch_id = '{BRANCHID}')";
                 * sql += " where user_id = '{USERID}' and user_branch_id = '{BRANCHID}'";
                 * sql = sql.Replace("{USERID}", USERID);
                 * sql = sql.Replace("{BRANCHID}", BRANCHID);
                 * Con_Oracle.ExecuteNonQuery(sql);
                 */

                Con_Oracle.CommitTransaction();
            }
            catch (Exception Ex)
            {
                if (Con_Oracle != null)
                {
                    Con_Oracle.RollbackTransaction();
                    Con_Oracle.CloseConnection();
                }
                throw Ex;
            }
            Con_Oracle.CloseConnection();
            return(RetData);
        }
        public Dictionary <string, object> SaveDetail(tablesd Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string  ErrorMessage = "";
            Boolean retvalue     = false;

            string sql1 = "";

            DBRecord Rec = null;

            string flag = "";

            int iOrder = 0;

            try
            {
                Con_Oracle = new DBConnection();

                if (Record.tabd_col_name.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Column Name Cannot Be Empty");
                }

                if (Record.tabd_col_caption.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Column Caption Cannot Be Empty");
                }

                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                Record.tabd_col_name = Record.tabd_col_name.ToUpper().Replace(" ", "");

                if ((ErrorMessage = AllValid2(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if (Record.rec_mode == "ADD" && Record.tabd_col_order <= 0)
                {
                    sql = "select nvl(max(tabd_col_order),10) + 10 from tablesd where rec_company_code = '" + Record._globalvariables.comp_code + "'";
                    if (Con_Oracle.DB == "SQL")
                    {
                        sql = "select isnull(max(tabd_col_order),10) + 10 from tablesd where rec_company_code = '" + Record._globalvariables.comp_code + "'";
                    }
                    sql   += " and tabd_parent_id ='" + Record.tabd_parent_id + "'";
                    iOrder = Lib.Conv2Integer(Con_Oracle.ExecuteScalar(sql).ToString());
                }

                Rec = new DBRecord();
                Rec.CreateRow("tablesd", Record.rec_mode, "tabd_pkid", Record.tabd_pkid);
                Rec.InsertString("tabd_col_caption", Record.tabd_col_caption, "P");
                Rec.InsertString("tabd_col_type", Record.tabd_col_type, "U");
                Rec.InsertString("tabd_col_case", Record.tabd_col_case, "U");
                Rec.InsertString("tabd_col_mandatory", Record.tabd_col_mandatory, "U");

                Rec.InsertString("tabd_col_id", Record.tabd_col_id, "P");
                Rec.InsertString("tabd_col_value", Record.tabd_col_value, "P");
                Rec.InsertString("tabd_col_list", Record.tabd_col_list, "P");



                Rec.InsertNumeric("tabd_col_rows", Record.tabd_col_rows.ToString());
                Rec.InsertNumeric("tabd_col_len", Record.tabd_col_len.ToString());
                Rec.InsertNumeric("tabd_col_dec", Record.tabd_col_dec.ToString());


                Rec.InsertString("rec_deleted", (Record.rec_deleted) ? "Y" : "N");

                if (Record.rec_mode == "ADD")
                {
                    if (Record.tabd_col_order > 0)
                    {
                        Rec.InsertNumeric("tabd_col_order", Record.tabd_col_order.ToString());
                    }
                    else
                    {
                        Rec.InsertNumeric("tabd_col_order", iOrder.ToString());
                    }

                    Rec.InsertString("tabd_parent_id", Record.tabd_parent_id);
                    Rec.InsertString("tabd_col_name", Record.tabd_col_name, "U");

                    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.InsertNumeric("tabd_col_order", Record.tabd_col_order.ToString());
                    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()");
                    }
                }


                if (Record.rec_mode == "ADD")
                {
                    flag = " ADD ";
                }

                if (Con_Oracle.DB == "ORACLE")
                {
                    if (Record.rec_mode == "EDIT")
                    {
                        flag = " MODIFY ";
                    }
                }
                else
                {
                    if (Record.rec_mode == "EDIT")
                    {
                        flag = " ALTER COLUMN ";
                    }
                }


                sql1 = "";

                if (Record.tabd_col_type == "TEXT" || Record.tabd_col_type == "MEMO")
                {
                    if (Con_Oracle.DB == "ORACLE")
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " nvarchar2(" + Record.tabd_col_len + ")";
                    }
                    else
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " nvarchar(" + Record.tabd_col_len + ")";
                    }
                }

                if (Record.tabd_col_type == "NUMBER")
                {
                    if (Con_Oracle.DB == "ORACLE")
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " number(" + Record.tabd_col_len + "," + Record.tabd_col_dec + ")";
                    }
                    else
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " numeric(" + Record.tabd_col_len + "," + Record.tabd_col_dec + ")";
                    }
                }

                if (Record.tabd_col_type == "DATE")
                {
                    if (Con_Oracle.DB == "ORACLE")
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " DATE";
                    }
                    else
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " DATETIME";
                    }
                }

                if (Record.tabd_col_type == "LIST")
                {
                    if (Con_Oracle.DB == "ORACLE")
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " nvarchar2(40)";
                    }
                    else
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " nvarchar(40)";
                    }
                }

                if (Record.tabd_col_type == "FILE")
                {
                    if (Con_Oracle.DB == "ORACLE")
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " nvarchar2(100)";
                    }
                    else
                    {
                        sql1 += "COL_" + Record.tabd_col_name + " nvarchar(100)";
                    }
                }

                if (sql1 != "")
                {
                    sql1 = " ALTER TABLE " + Record.tabd_table_name.ToUpper() + " " + flag + " " + sql1;
                }

                sql = Rec.UpdateRow();
                Con_Oracle.BeginTransaction();
                if (sql1 != "")
                {
                    Con_Oracle.ExecuteNonQuery(sql1);
                }
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                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("col_name", Record.tabd_col_name);
            RetData.Add("iorder", iOrder);

            return(RetData);
        }
        public Dictionary <string, object> Save(tablesm Record)
        {
            Dictionary <string, object> RetData = new Dictionary <string, object>();
            string  ErrorMessage = "";
            Boolean retvalue     = false;

            string sql1 = "";

            DBRecord Rec = null;

            int iOrder = 0;

            try
            {
                Con_Oracle = new DBConnection();

                if (Record.tab_name.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Table Name Cannot Be Empty");
                }

                if (Record.tab_caption.Trim().Length <= 0)
                {
                    Lib.AddError(ref ErrorMessage, "Caption Cannot Be Empty");
                }

                if (ErrorMessage != "")
                {
                    throw new Exception(ErrorMessage);
                }

                if ((ErrorMessage = AllValid(Record)) != "")
                {
                    throw new Exception(ErrorMessage);
                }

                Rec = new DBRecord();
                Rec.CreateRow("tablesm", Record.rec_mode, "tab_pkid", Record.tab_pkid);
                Rec.InsertString("tab_caption", Record.tab_caption, "P");

                Rec.InsertString("tab_id", Record.tab_id, "P");
                Rec.InsertString("tab_store", Record.tab_store, "P");
                Rec.InsertString("tab_group", Record.tab_group, "P");
                Rec.InsertString("tab_sku", Record.tab_sku, "P");
                Rec.InsertString("tab_file", Record.tab_file, "P");

                Rec.InsertString("tab_sku_duplication", Record.tab_sku_duplication ? "Y" : "N");
                Rec.InsertString("tab_store_duplication", Record.tab_store_duplication ? "Y" : "N");
                Rec.InsertString("tab_campaign_table", Record.tab_campaign_table ? "Y" : "N");


                if (Record.rec_mode == "ADD")
                {
                    // Table Creation
                    Record.tab_table_name = "TBL_" + Record._globalvariables.comp_code + "_" + Record.tab_name.ToUpper();
                    Rec.InsertString("tab_name", Record.tab_name, "U");
                    Rec.InsertString("tab_table_name", Record.tab_table_name, "U");
                    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()");
                    }
                }

                if (Record.rec_mode == "ADD")
                {
                    sql1 = "";
                    if (Con_Oracle.DB == "ORACLE")
                    {
                        sql1 += " CREATE TABLE " + Record.tab_table_name;
                        sql1 += " (  ";
                        //sql1 += " DOC_PKID          NVARCHAR2(40), ";
                        sql1 += " DOC_PARENT_ID        NVARCHAR2(40), ";
                        //sql1 += " DOC_SLNO          NUMBER(15),    ";
                        //sql1 += " DOC_TABLE_NAME    NVARCHAR2(60), ";
                        //sql1 += " DOC_NAME          NVARCHAR2(100), ";
                        //sql1 += " DOC_FILE_NAME     NVARCHAR2(100), ";
                        sql1 += " REC_COMPANY_CODE  NVARCHAR2(10), ";
                        sql1 += " REC_CREATED_BY    NVARCHAR2(15), ";
                        sql1 += " REC_CREATED_DATE  DATE,          ";
                        sql1 += " REC_EDITED_BY     NVARCHAR2(15), ";
                        sql1 += " REC_EDITED_DATE   DATE ";
                        sql1 += " ) ";
                    }
                    else
                    {
                        sql1 += " CREATE TABLE " + Record.tab_table_name;
                        sql1 += " (  ";
                        //sql1 += " DOC_PKID          NVARCHAR(40), ";
                        sql1 += " DOC_PARENT_ID        NVARCHAR(40), ";
                        //sql1 += " DOC_SLNO          NUMERIC(15),    ";
                        //sql1 += " DOC_TABLE_NAME    NVARCHAR(60), ";
                        //sql1 += " DOC_NAME          NVARCHAR(100), ";
                        //sql1 += " DOC_FILE_NAME     NVARCHAR(100), ";
                        sql1 += " REC_COMPANY_CODE  NVARCHAR(10), ";
                        sql1 += " REC_CREATED_BY    NVARCHAR(15), ";
                        sql1 += " REC_CREATED_DATE  DATETIME,          ";
                        sql1 += " REC_EDITED_BY     NVARCHAR(15), ";
                        sql1 += " REC_EDITED_DATE   DATETIME ";
                        sql1 += " ) ";
                    }
                }
                sql = Rec.UpdateRow();


                Rec = new DBRecord();
                Rec.CreateRow("menum", Record.rec_mode, "menu_pkid", Record.tab_pkid);

                Rec.InsertString("menu_code", "~PIM~" + Record.tab_name.ToUpper());
                Rec.InsertString("menu_name", Record.tab_caption, "P");
                Rec.InsertString("menu_route1", "pim/pim", "P");
                string str = "urlid" + ":" + "PIM" + "menuid" + ":" + "PIM" + "," + "type" + ":" + "TBL_VTC_PRODUCT";
                str = "{ \"urlid\":\"{PIM}\",\"menuid\":\"{PIM}\",\"type\":\"{TBL}\"}";

                str = str.Replace("{PIM}", "~PIM~" + Record.tab_name.ToUpper());
                str = str.Replace("{TBL}", Record.tab_table_name.ToUpper());

                Rec.InsertString("menu_route2", str, "P");
                Rec.InsertString("menu_type", "AEDP");
                Rec.InsertString("menu_displayed", "Y");


                if (Record.rec_mode == "ADD")
                {
                    string sql10 = "select nvl(max(menu_order),10) + 10 from menum where rec_company_code = '" + Record._globalvariables.comp_code + "'";
                    if (Con_Oracle.DB == "SQL")
                    {
                        sql10 = "select isnull(max(menu_order),10) + 10 from menum where rec_company_code = '" + Record._globalvariables.comp_code + "'";
                    }
                    iOrder = Lib.Conv2Integer(Con_Oracle.ExecuteScalar(sql10).ToString());

                    Rec.InsertString("menu_order", iOrder.ToString());
                    Rec.InsertString("menu_module_id", "3C784E47-4EC4-AF88-60F0-8555036656FA");
                    Rec.InsertString("rec_company_code", Record._globalvariables.comp_code);
                }
                string sql2 = Rec.UpdateRow();

                Con_Oracle.BeginTransaction();
                if (sql1 != "")
                {
                    Con_Oracle.ExecuteNonQuery(sql1);
                }
                Con_Oracle.ExecuteNonQuery(sql);
                Con_Oracle.ExecuteNonQuery(sql2);

                Con_Oracle.CommitTransaction();
                Con_Oracle.CloseConnection();
                retvalue = true;
            }
            catch (Exception Ex)
            {
                if (Con_Oracle != null)
                {
                    Con_Oracle.RollbackTransaction();
                    Con_Oracle.CloseConnection();
                }
                retvalue = false;
                throw Ex;
            }
            Con_Oracle.CloseConnection();
            RetData.Add("table_name", Record.tab_table_name);
            RetData.Add("retvalue", retvalue);

            return(RetData);
        }