private void LoadLeadTimeKpi(string orcId)
{
//vai entrar no metodo do botao
if (orcId != "Selecione")
{
//LoadLeadTimeKpi(Convert.ToInt32(orcamento_id));
BudgetBD budgetBD = new BudgetBD();
DataSet ds = budgetBD.SelectPreviousFinishedBudget(Convert.ToInt32(orcId));
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
gdvLeadTimeKpi.DataSource = ds.Tables[0].DefaultView;
gdvLeadTimeKpi.DataBind();
gdvLeadTimeKpi.HeaderRow.TableSection = TableRowSection.TableHeader;
//lblMessage.Visible = false;
}
FinishedBudget start = budgetBD.SelectStartDateById(Convert.ToInt32(orcId));
FinishedBudget end = budgetBD.SelectEndDateById(Convert.ToInt32(orcId));
double diasAcumulados = (end.FinishedDate - start.StartDate).TotalDays;
Label2.Visible = true;
lblDiasAcumulados.Visible = true;
lblDiasAcumulados.Text = " " + Convert.ToString(diasAcumulados);
}
else
{
gdvLeadTimeKpi.Visible = false;
}
}
protected void sendEmail(int etdId)
{
int orcId = Convert.ToInt32(Request.QueryString["orc_id"]);
BudgetBD bd = new BudgetBD();
Budget budget = bd.SelectById(orcId);
string etapa = null;
if (etdId == 1)
{
etapa = listEtapa.SelectedItem.Text;
}
else
{
etapa = lblNextStep.Text;
}
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "MF Movelaria");
mail.To.Add(budget.Email);
mail.Subject = "Atualizaçao do projeto";
mail.IsBodyHtml = true;
mail.Body = "<h2>Olá, querido cliente!</h2>" +
"<p>belezinha?</p>" +
"<p>Seu lindo projeto, feito com amor está na etapa de produção: " + etapa + "</p>" +
"<p><span style='font-size:12px'><span style='color:#000000'><span style='font-family:arial,helvetica,sans-serif'>Atenciosamente,</span></span></span></p>" +
"<p><span style='font-size:12px'><span style='color:#000000'><span style='font-family:arial,helvetica,sans-serif'>MF Movelaria.</span></span></span></p>" +
"<p style='text-align:center'><span style='font - size:12px'><span style='color:#000000'><span style='font-family:arial,helvetica,sans-serif'>Contato:</span></span></span></p>" +
"<div style='text-align: center;'><font color='#000000' face='arial, helvetica, sans-serif'><span style='font-size:12px'>(12) 3152-2515</span></font></div>" +
"<p style='text-align:center'><span style='font-size:12px'><span style='color:#000000'><span style='font-family:arial,helvetica,sans-serif'>Av. Gen. Eduardo Areco, 606 - Vila Geny, Lorena - SP, CEP: 12604-100</span></span></span></p>";
SmtpClient sc = new SmtpClient("smtp.gmail.com");
sc.Port = 587;
sc.EnableSsl = true;
sc.UseDefaultCredentials = false;
sc.Credentials = new NetworkCredential("movelariamf", "mf_moveis*2019");
try
{
sc.Send(mail);
lblMessage.CssClass = "text-success";
lblMessage.Text = "Pedido enviado com sucesso.";
Clear();
}
catch (Exception ex)
{
lblMessage.CssClass = "text-danger";
lblMessage.Text = "Erro ao enviar o e-mail.";
}
}
private void LoadFinishedBudgets()
{
BudgetBD db = new BudgetBD();
DataSet ds = db.SelectAllFinished();
ddlFinishedBudgets.DataSource = ds.Tables[0].DefaultView;
ddlFinishedBudgets.DataTextField = "orc_id";
ddlFinishedBudgets.DataValueField = "orc_id";
ddlFinishedBudgets.DataBind();
ddlFinishedBudgets.Items.Insert(0, "Selecione");
}
private bool checkBudgetStatus(int orcId)
{
BudgetBD budgetBD = new BudgetBD();
Budget budget = budgetBD.SelectById(orcId);
if (budget != null)
{
return(budget.Active);
}
return(true);
}
protected void loadBudgetFields(int orcId)
{
BudgetBD budgetBD = new BudgetBD();
Budget budget = budgetBD.SelectById(orcId);
if (budget != null)
{
lblMessage.Visible = false;
lblOrcamento.Text = budget.Id.ToString();
lblDataInicio.Text = budget.StartDate.ToString("dd/MM/yyyy");
lblTotal.Text = ("R$" + budget.TotalBudget).ToString();
lblCliente.Text = budget.Email.ToString();
lblResponsavel.Text = budget.NameEmployee.ToString();
}
else
{
lblMessage.Visible = true;
}
}
protected void gdvOrc_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Cancelar")
{
BudgetBD bd = new BudgetBD();
Budget budget = new Budget();
int rowIndex = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gdvBudget.Rows[rowIndex];
string strStatus = row.Cells[5].Text;
budget.Id = Convert.ToInt32(row.Cells[0].Text);
if (strStatus.Equals("True"))
{
if (bd.UpdateBudget(budget))
{
Response.Redirect(Request.RawUrl, false);
}
}
else
{
Response.Redirect(Request.RawUrl, false);
}
}
if (e.CommandName == "Etapa")
{
string orc_id = e.CommandArgument.ToString();
Response.Redirect("http://localhost:54362/Pages/StepPages/Register.aspx?orc_id=" + orc_id);
}
if (e.CommandName == "Pedido")
{
string orc_id = e.CommandArgument.ToString();
Response.Redirect("../OrderPages/ListOrders.aspx?orc_id=" + orc_id);
}
}
private void CarryBudgets()
{
BudgetBD bd = new BudgetBD();
DataSet ds = bd.SelectAll();
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
gdvBudget.DataSource = ds.Tables[0].DefaultView;
gdvBudget.DataBind();
gdvBudget.HeaderRow.TableSection = TableRowSection.TableHeader;
lblMessage.Visible = false;
lblStatus.Visible = true;
}
else
{
lblMessage.Visible = true;
lblStatus.Visible = false;
}
}
protected void btnSalvar_Click(object sender, EventArgs e)
{
int id = 0;
BudgetBD orcamentobd = new BudgetBD();
if (Session["ID"] != null)
{
id = Convert.ToInt32(Session["ID"]);
}
bool sucesso = true;
if (orcamentobd.Insert(DateTime.Now, GridView1.Rows[0].Cells[0].Text, GridView1.Rows[0].Cells[1].Text, id))
{
BudgetItemBD orcamentoItem = new BudgetItemBD();
BudgetBD budget = new BudgetBD();
int lastId = budget.SelectLastBudget();
for (int j = 0; j < GridView1.Rows.Count; j++)
{
if (orcamentoItem.Insert(GridView1.Rows[j].Cells[2].Text, GridView1.Rows[j].Cells[3].Text, GridView1.Rows[j].Cells[4].Text, GridView1.Rows[j].Cells[5].Text, 1, lastId))
{
sucesso = true;
}
else
{
sucesso = false;
}
}
}
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
//}
}
