public bool Put(NewTicketEntity entity)
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@TicketID", (entity.ticket_id).ToString()));
sqlParameters.Add(new KeyValuePair <string, string>("@assingedTo", (entity.assingedTo).ToString()));
sqlParameters.Add(new KeyValuePair <string, string>("@Ticketstatus", entity.Ticketstatus));
sqlParameters.Add(new KeyValuePair <string, string>("@short_desc", entity.short_desc));
// sqlParameters.Add(new KeyValuePair<string, string>("@URL", entity.URL));
sqlParameters.Add(new KeyValuePair <string, string>("@StatusCode", (entity.StatusCode).ToString()));
sqlParameters.Add(new KeyValuePair <string, string>("@CC", entity.CC));
var result = manageSQLConnection.UpdateValues("UpdateTickets", sqlParameters);
MailSending mailSending = new MailSending();
//Mail sending
MailEntity mailEntity = new MailEntity
{
FromMailid = GlobalVariables.FromMailid,
FromPassword = GlobalVariables.Password,
ToMailid = entity.assingedTo,
ToCC = entity.bodyMessage.TOCC,
Port = GlobalVariables.Port,
Subject = entity.short_desc,
BodyMessage = mailSending.BodyMessage(entity.bodyMessage, entity.ticket_id),
SMTP = GlobalVariables.Host
};
mailSending.Send(mailEntity);
return(result);
}
public Tuple <bool, string, string> Post(NewTicketEntity ticketEntity)
{
MySqlCommand cmd = new MySqlCommand();
// ManageSQLConnection sqlConnection = new ManageSQLConnection();
MySqlConnection sqlConnection = new MySqlConnection();
MySqlTransaction objTrans = null;
string connectionString = GlobalVariables.ConnectionString;
using (sqlConnection = new MySqlConnection(connectionString))
{
DataSet ds = new DataSet();
cmd = new MySqlCommand();
try
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
objTrans = sqlConnection.BeginTransaction();
cmd.Transaction = objTrans;
cmd.Connection = sqlConnection;
cmd.CommandText = "InsertNewTicket";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Region", ticketEntity.Region);
cmd.Parameters.AddWithValue("@District", ticketEntity.District);
cmd.Parameters.AddWithValue("@Shops", ticketEntity.Shops);
cmd.Parameters.AddWithValue("@assingedTo", ticketEntity.assingedTo);
cmd.Parameters.AddWithValue("@Ticketseverity", ticketEntity.Ticketseverity);
cmd.Parameters.AddWithValue("@Ticketstatus", ticketEntity.Ticketstatus);
cmd.Parameters.AddWithValue("@short_desc", ticketEntity.short_desc);
cmd.Parameters.AddWithValue("@product", ticketEntity.product);
cmd.Parameters.AddWithValue("@reporter", ticketEntity.reporter);
cmd.Parameters.AddWithValue("@component_id", ticketEntity.component_id);
// cmd.Parameters.AddWithValue("@URL", ticketEntity.URL);
cmd.Parameters.AddWithValue("@status_code", (ticketEntity.StatusCode).ToString());
cmd.Parameters.AddWithValue("@userid", ticketEntity.UserId);
cmd.Parameters.AddWithValue("@CC", ticketEntity.CC);
cmd.Parameters.AddWithValue("@everconfirmed", ticketEntity.everconfirmed);
cmd.Parameters.AddWithValue("@reporter_accessible", ticketEntity.reporter_accessible);
cmd.Parameters.AddWithValue("@cclist_accessible", ticketEntity.cclist_accessible);
//cmd.Parameters.AddWithValue("@ticket_id", ticketEntity.ticket_id).Direction = ParameterDirection.Output;
//string id = cmd.Parameters["@ticket_id"].Value.ToString();
//LblMessage.Text = "Record inserted successfully. ID = " + id;
int insertedID = Convert.ToInt32(cmd.ExecuteScalar());
string insertID = insertedID.ToString();
objTrans.Commit();
cmd.Parameters.Clear();
cmd.Dispose();
MailSending mailSending = new MailSending();
//Mail sending
MailEntity mailEntity = new MailEntity
{
FromMailid = GlobalVariables.FromMailid,
FromPassword = GlobalVariables.Password,
ToMailid = ticketEntity.assingedTo,
ToCC = ticketEntity.bodyMessage.TOCC,
Port = GlobalVariables.Port,
Subject = ticketEntity.short_desc,
BodyMessage = mailSending.BodyMessage(ticketEntity.bodyMessage, insertedID),
SMTP = GlobalVariables.Host
};
mailSending.Send(mailEntity);
return(new Tuple <bool, string, string>(true, JsonConvert.SerializeObject(ds), insertID));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
objTrans.Rollback();
return(new Tuple <bool, string, string>(false, "Exception occured", "No value return"));
}
finally
{
sqlConnection.Close();
cmd.Dispose();
ds.Dispose();
}
}
}
