Example #1
0
        public ImportCDO.CommonReturnCDO InsertDate(ImportCDO.CommonModel commonPassParameter)
        {
            CommonReturnCDO objReturnCDO = new CommonReturnCDO();
            DataSet         ds           = new DataSet();
            SqlCommand      cmd          = null;
            ImportFileCDO   objcdo       = null;

            try
            {
                objcdo          = (ImportFileCDO)commonPassParameter;
                cmd             = GetCommand();
                cmd.CommandText = "USPInsertImport";
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("StoreName", objcdo.StoreName);
                cmd.Parameters.AddWithValue("SourcePath", objcdo.SourcePath);
                cmd.Parameters.AddWithValue("CreatedBy", objcdo.CreatedBy);
                cmd.Parameters.AddWithValue("CreatedOn", objcdo.CreatedDate);
                cmd.Parameters.AddWithValue("IsActive", objcdo.IsActive);
                cmd.ExecuteNonQuery();
                foreach (var importfiledata in objcdo.importfilecdo)
                {
                    cmd.CommandText = "USPInsertImportData";
                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("Name", importfiledata.Name);
                    cmd.Parameters.AddWithValue("TwitterId", importfiledata.TwitterId);
                    cmd.Parameters.AddWithValue("CategoryGUID", importfiledata.CategoryGUID);
                    cmd.ExecuteNonQuery();

                    foreach (var category in importfiledata.Categories)
                    {
                        cmd.CommandText = "USPInsertImportDataCategory";
                        cmd.Parameters.Clear();
                        cmd.Parameters.AddWithValue("Name", category);
                        cmd.Parameters.AddWithValue("@CategoryGUID", importfiledata.CategoryGUID);

                        cmd.ExecuteNonQuery();
                    }
                }


                cmd.Transaction.Commit();
                objReturnCDO.IsSuccess = true;
                return(objReturnCDO);
            }
            catch (Exception ex)
            {
                return(objReturnCDO);
            }
            finally { cmd.Connection.Close(); }
        }
Example #2
0
 public ImportCDO.CommonReturnCDO DeleteData(ImportCDO.CommonModel commonPassParameter)
 {
     throw new NotImplementedException();
 }