public static void ModifyPret(ServiceSocial serviceSocial)
{
SqlConnection sqlConnection = new SqlConnection(constr);
if (sqlConnection.State == ConnectionState.Closed)
{
sqlConnection.Open();
}
string command = "UPDATE " + table + " SET remb1=@remb1 , date1=@date1, " +
" remb2=@remb2 , date2=@date2," +
"remb3=@remb3 , date3=@date3," +
"remb10=@remb10 , date10=@date10," +
"remb4=@remb4 , date4=@date4," +
"remb5=@remb5 , date5=@date5," +
"remb6=@remb6 , date6=@date6," +
"remb7=@remb7 , date7=@date7," +
"remb8=@remb8 , date8=@date8," +
"remb9=@remb9 , date9=@date9 , observation=@observation " +
" WHERE Id=@id ;";
SqlCommand sqlCommand = new SqlCommand(command, sqlConnection);
using (sqlCommand)
{
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.AddWithValue("@id", serviceSocial.getid());
int j;
for (int i = 0; i < serviceSocial.getprelevements().Count; i++)
{
j = i + 1;
String str = "@remb" + j;
sqlCommand.Parameters.AddWithValue(str, serviceSocial.getprelevement(i));
}
for (int i = 0; i < serviceSocial.getDates().Count; i++)
{
j = i + 1;
String str = "@date" + j;
sqlCommand.Parameters.AddWithValue(str, serviceSocial.getDate(i));
}
for (int i = serviceSocial.getDates().Count; i < 10; i++)
{
j = i + 1;
String str = "@date" + j;
sqlCommand.Parameters.AddWithValue(str, DBNull.Value);
}
if (String.IsNullOrEmpty(serviceSocial.getobservation()))
{
sqlCommand.Parameters.AddWithValue("@observation", DBNull.Value);
}
else
{
sqlCommand.Parameters.AddWithValue("@observation", serviceSocial.getobservation());
}
sqlCommand.ExecuteNonQuery();
}
sqlCommand.Dispose();
sqlConnection.Close();
}
public static void AddPret(ServiceSocial serviceSocial)
{
SqlConnection sqlConnection = new SqlConnection(constr);
sqlConnection.Open();
String Command = "INSERT INTO " + table + " VALUES (@Id , @Emp , @service ," +
"@pv , @somme , @remb1 , @date1 , @remb2 , @date2 , @remb3 , @date3" +
", @remb4 , @date4 , @remb5 , @date5" +
", @remb6 , @date6 , @remb7 , @date7 , @remb8 , @date8" +
", @remb9 , @date9 , @remb10 , @date10 ,@observation ,@type ) ; ";
SqlCommand sqlCommand = new SqlCommand(Command, sqlConnection);
using (sqlCommand)
{
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.AddWithValue("@Id", serviceSocial.getid());
sqlCommand.Parameters.AddWithValue("@Emp", serviceSocial.getEmployer());
if (serviceSocial is PretSociale)
{
sqlCommand.Parameters.AddWithValue("@service", 1);
}
else if (serviceSocial is Dons)
{
sqlCommand.Parameters.AddWithValue("@service", 2);
}
else // Credit Electromenager
{
sqlCommand.Parameters.AddWithValue("@service", 3);
}
sqlCommand.Parameters.AddWithValue("@pv", serviceSocial.getPV().getId());
sqlCommand.Parameters.AddWithValue("@somme", serviceSocial.getPrix());
int j;
for (int i = 0; i < serviceSocial.getprelevements().Count; i++)
{
j = i + 1;
String str = "@remb" + j;
sqlCommand.Parameters.AddWithValue(str, serviceSocial.getprelevement(i));
}
for (int i = 0; i < serviceSocial.getDates().Count; i++)
{
j = i + 1;
String str = "@date" + j;
sqlCommand.Parameters.AddWithValue(str, serviceSocial.getDate(i));
}
for (int i = serviceSocial.getDates().Count; i < 10; i++)
{
j = i + 1;
String str = "@date" + j;
sqlCommand.Parameters.AddWithValue(str, DBNull.Value);
}
if (String.IsNullOrEmpty(serviceSocial.getobservation()))
{
sqlCommand.Parameters.AddWithValue("@observation", DBNull.Value);
}
else
{
sqlCommand.Parameters.AddWithValue("@observation", serviceSocial.getobservation());
}
if (serviceSocial is Pret)
{
TypePret type = ((Pret)serviceSocial).getTypePret();
sqlCommand.Parameters.AddWithValue("@type", type.Id);
}
else
{
sqlCommand.Parameters.AddWithValue("@type", DBNull.Value);
}
sqlCommand.ExecuteNonQuery();
}
sqlCommand.Dispose();
sqlConnection.Close();
try
{
if (serviceSocial is Electromenager)
{
ConnectionBonCmd.AddBonCmd(((Electromenager)serviceSocial).GetBon_Cmd());
ConnectionFacture.AddFacture(((Electromenager)serviceSocial).GetFacture());
}
}
catch { }
}