public void insertIntoStaging(PLConvert.PCLawConversion PCLaw)
{
using (SqlConnection connection = new SqlConnection("Data Source=localhost;Initial Catalog=PCLawStg;Integrated Security=SSPI;"))
{
connection.Open();
while (PCLaw.User.GetNextRecord() == 0)
{
if (PCLaw.User.Status == PLConvert.PLXMLData.eSTATUS.ACTIVE)
{
using (SqlCommand command1 = new SqlCommand())
{
command1.Connection = connection;
command1.CommandType = CommandType.Text;
command1.CommandText = "INSERT into [User] ([UserID], [nickname], [Name], [password]) VALUES (@UserID, @nickname, @Name, @Password)";
command1.Parameters.AddWithValue("@UserID", PCLaw.User.ID);
command1.Parameters.AddWithValue("@nickname", PCLaw.User.NickName);
command1.Parameters.AddWithValue("@Name", PCLaw.User.Name);
command1.Parameters.AddWithValue("@Password", "admin");
// try
// {
command1.ExecuteNonQuery();
//}
// catch (SqlException ex1)
// {
// MessageBox.Show(ex1.Message);
//}
}
}
}
}
}
public FinancialConversionForm(string connString, bool existData, bool closedMaters)
{
InitializeComponent();
connectionString = connString;
existingData = existData;
includeClosedMatters = closedMaters;
Conversion = new ConversionControl(includeClosedMatters);
if (ConversionControl.PCLaw != null)
{
PCLaw = ConversionControl.PCLaw;
}
else
{
PCLaw = new PLConvert.PCLawConversion();
}
}
public ProgressForm(string connString, bool existingdata, bool inclClosedMatters, bool inclWIPfees, bool inclWIPexp, bool inclAR, bool inclTrust)
{
InitializeComponent();
//variable assignments
connectionString = connString;
includeClosedMatters = inclClosedMatters;
useExistingData = existingdata;
Conversion = new ConversionControl(inclClosedMatters);
if (ConversionControl.PCLaw != null)
{
PCLaw = ConversionControl.PCLaw;
}
else
{
PCLaw = new PLConvert.PCLawConversion();
}
label11.Visible = inclWIPfees;
label12.Visible = inclWIPexp;
label14.Visible = inclAR;
label13.Visible = inclTrust;
//get a list of all labels so we know what and how to process the items
List <Label> tempList = this.Controls.OfType <Label>().ToList();
List <Label> labelList = new List <Label>();
foreach (Label c in tempList)
{
if (c.Visible != true)
{
labelList.Add(c);
}
}
SupportOperations supportOp = new SupportOperations();
convObjList = supportOp.createConvObjects(labelList).ToList();
//Control method calls
beginConversion();
finishConversion();
}
public abstract void AddRecords(PLConvert.PCLawConversion PL, bool bPCLawMoreUptoDate);
}//end method
public override void AddRecords(PLConvert.PCLawConversion PL, bool bPCLawMoreUptoDate)
{
//not used
}//end if
}//end constructor
public AMClient(PLConvert.PCLawConversion PL)
{
PCLaw = PL;
}//end constructor
}//end constructor
public AMUser(PLConvert.PCLawConversion PL)
{
PCLaw = PL;
}//end constructor
}//en constructor
public AMTypeOfLaw(PLConvert.PCLawConversion PL)
{
PCLaw = PL;
}//end constructor
