protected void grdItemManutencao_InsertCommand(object sender, GridCommandEventArgs e)
{
try
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
ItemManutencao _itemManutencao = new ItemManutencao();
_itemManutencao.RegistroManutencaoID = int.Parse(Request["RegistroManutencaoID"]);
_itemManutencao.Descricao = (insertedItem["colDescricao"].Controls[0] as TextBox).Text;
_itemManutencao.Lote = (insertedItem["colLote"].Controls[0] as TextBox).Text;
_itemManutencao.NumeroSerie = (insertedItem["colNumeroSerie"].Controls[0] as TextBox).Text;
_itemManutencao.Quantidade = ((insertedItem["colQuantidade"].Controls[0] as RadNumericTextBox).Value != null) ? decimal.Parse((insertedItem["colQuantidade"].Controls[0] as RadNumericTextBox).Value.ToString()) : 0;
_itemManutencao.Custo = ((insertedItem["colCusto"].Controls[0] as RadNumericTextBox).Value != null) ? decimal.Parse((insertedItem["colCusto"].Controls[0] as RadNumericTextBox).Value.ToString()) : 0;
_itemManutencao.DataCriacao = DateTime.Now;
_itemManutencao.UsuarioCriador = int.Parse(Session["ssnLoggedUserID"].ToString());
_itemManutencao.DataModificacao = DateTime.Now;
_itemManutencao.UsuarioModificador = int.Parse(Session["ssnLoggedUserID"].ToString());
using (UnitOfWork oUnitOfWork = new UnitOfWork())
{
oUnitOfWork.ItemManutencaoREP.Adicionar(_itemManutencao);
oUnitOfWork.Save();
}
Utils.Notificar(ntfGeral, "Registro de produto inserido com sucesso.", Enums.TipoNotificacao.Informacao);
}
catch (Exception ex)
{
e.Canceled = true;
Log.Trace(ex, true);
Utils.Notificar(ntfGeral, "Falha ao tentar incluir registro de produto.", Enums.TipoNotificacao.Erro);
}
}
protected void grdEndereco_InsertCommand(object sender, GridCommandEventArgs e)
{
try
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
Endereco _endereco = new Endereco();
_endereco.EntidadeID = int.Parse(Request["EntidadeID"]);
_endereco.Cep = (insertedItem["colCEP"].FindControl("txtCEP") as RadMaskedTextBox).Text;
_endereco.Logradouro = (insertedItem["colLogradouro"].FindControl("txtLogradouro") as RadTextBox).Text;
_endereco.Numero = int.Parse((insertedItem["colNumero"].FindControl("txtNumero") as RadMaskedTextBox).Text);
_endereco.Complemento = (insertedItem["colComplemento"].FindControl("txtComplemento") as RadTextBox).Text;
_endereco.Bairro = (insertedItem["colBairro"].FindControl("txtBairro") as RadTextBox).Text;
_endereco.CidadeID = int.Parse((insertedItem["colCidade"].FindControl("hdnCidadeID") as HiddenField).Value);
_endereco.EnderecoTipoID = int.Parse((insertedItem["colEnderecoTipo"].Controls[1] as RadComboBox).SelectedValue);
_endereco.DataCriacao = DateTime.Now;
_endereco.UsuarioCriadorID = int.Parse(Session["ssnLoggedUserID"].ToString());
_endereco.DataModificacao = DateTime.Now;
_endereco.UsuarioModificadorID = int.Parse(Session["ssnLoggedUserID"].ToString());
using (UnitOfWork oUnitOfWork = new UnitOfWork())
{
oUnitOfWork.EnderecoREP.Adicionar(_endereco);
oUnitOfWork.Save();
// Se o canal for principal, os outros devem ser "não principais"
if ((insertedItem["colIsPrincipal"].Controls[0] as CheckBox).Checked)
{
oUnitOfWork.EnderecoREP.AplicarRegistroPrincipal(_endereco);
oUnitOfWork.Save();
}
else
{
oUnitOfWork.EnderecoREP.RemoverRegistroPrincipal(_endereco);
oUnitOfWork.Save();
}
}
Utils.Notificar(ntfGeral, "Registros de endereço atualizados.", Enums.TipoNotificacao.Informacao);
}
catch (Exception ex)
{
e.Canceled = true;
Log.Trace(ex, true);
Utils.Notificar(ntfGeral, "Falha ao tentar incluir registro de endereço.", Enums.TipoNotificacao.Erro);
}
}
protected void gridResponses_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
GridDataInsertItem gridItem = (GridDataInsertItem)e.Item;
RadTextBox txtResponseLetter = gridItem.FindControl("txtResponseLetter") as RadTextBox;
RadTextBox txtResponseText = gridItem.FindControl("txtResponseText") as RadTextBox;
RatingScaleResponseEntity entity = new RatingScaleResponseEntity();
entity.RatingScaleID = this.CurrentRsID;
entity.ResponseLetter = txtResponseLetter.Text;
entity.ResponseText = txtResponseText.Text;
entity.ID = jqm.AddRatingScaleResponse(entity, this.CurrentUserID);
BindData();
}
}
protected void rategrid_InsertCommand(object source, GridCommandEventArgs e)
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
string ReferenceID = (insertedItem["Sno"].Controls[3] as Label).Text;
string Rate = (insertedItem["Rate"].Controls[1] as RadNumericTextBox).Text;
string Family = (insertedItem["Family"].Controls[1] as RadNumericTextBox).Text;
string Fringe = (insertedItem["Fringe"].Controls[1] as RadNumericTextBox).Text;
bool hasValue = (insertedItem["Effective_Date"].Controls[1] as RadDatePicker).SelectedDate.HasValue;
string strEffective_Date = (hasValue ? (insertedItem["Effective_Date"].Controls[1] as RadDatePicker).SelectedDate.Value.ToShortDateString() : null);
string Effective_Date = strEffective_Date;
Repository.Struct.SpResultset resultset = Repository.Members.InsertRate(ReferenceID, Isdecimal(Rate), Isdecimal(Family), Isdecimal(Fringe), Effective_Date);
if (resultset.Isresult)
{
rategrid.Rebind();
e.Item.OwnerTableView.IsItemInserted = false;
}
}
protected void feegrid_InsertCommand(object source, GridCommandEventArgs e)
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
string ReferenceID = (insertedItem["Sno"].Controls[3] as Label).Text;
string Init_FullTime = (insertedItem["Init_FullTime"].Controls[1] as RadNumericTextBox).Text;
string Init_PartTime = (insertedItem["Init_PartTime"].Controls[1] as RadNumericTextBox).Text;
string Due_FullTime = (insertedItem["Due_FullTime"].Controls[1] as RadNumericTextBox).Text;
string Due_PartTime = (insertedItem["Due_PartTime"].Controls[1] as RadNumericTextBox).Text;
bool hasValue = (insertedItem["Effective_Date"].Controls[1] as RadDatePicker).SelectedDate.HasValue;
string strEffective_Date = (hasValue ? (insertedItem["Effective_Date"].Controls[1] as RadDatePicker).SelectedDate.Value.ToShortDateString() : null);
string Effective_Date = strEffective_Date;
Repository.Struct.SpResultset resultset = Repository.Shops.InsertFee(ReferenceID, Isdecimal(Init_FullTime), Isdecimal(Init_PartTime), Isdecimal(Due_FullTime), Isdecimal(Due_PartTime), Effective_Date);
if (resultset.Isresult)
{
feegrid.Rebind();
e.Item.OwnerTableView.IsItemInserted = false;
}
}
protected void grid_ItemDetail_InsertCommand(object source, GridCommandEventArgs e)
{
int RowID = e.Item.DataSetIndex;
GridDataInsertItem edititem = (GridDataInsertItem)e.Item;
DataTable dt_ItemLines = (DataTable)Session["dt_ItemLines"];
string ItemCode = ((RadTextBox)edititem["ItemCode"].FindControl("tbItemCode")).Text.Trim();
if (ItemCode == "")
{
return;
}
foreach (DataRow dr in dt_ItemLines.Rows)
{
if (ItemCode == (string)dr["ItemCode"])
{
grid_ItemDetail.Rebind();
return;
}
}
string ItemName = ((Label)edititem["ItemName"].FindControl("tbItemName")).Text.Trim();
string Unit = ((Label)edititem["Unit"].FindControl("tbUnit")).Text.Trim();
string UnitCost = ((Label)edititem["UnitCost"].FindControl("tbUnitCost")).Text.Trim();
decimal Quantity = Convert.ToDecimal(((RadNumericTextBox)edititem["Quantity"].FindControl("tbQuantity")).Text.Trim());
decimal Amount = Convert.ToDecimal(((RadNumericTextBox)edititem["Amount"].FindControl("tbAmount")).Text.Trim());
dt_ItemLines.Rows.Add(ItemCode, ItemName, Unit, UnitCost, Quantity, Amount, "Insert");
Session["dt_ItemLines"] = dt_ItemLines;
CalculateMRC(12);
grid_ItemDetail.Rebind();
}
protected void contactgrid_InsertCommand(object source, GridCommandEventArgs e)
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
string ReferenceID = (insertedItem["Sno"].Controls[3] as Label).Text;
string Name = (insertedItem["Name"].Controls[1] as TextBox).Text.ToUpper();
string Type = (insertedItem["Type"].Controls[3] as RadComboBox).SelectedValue;
string Other = (insertedItem["Type"].Controls[5] as TextBox).Text.ToUpper();
string Phone = (insertedItem["Phone"].Controls[1] as RadMaskedTextBox).Text;
string Fax = (insertedItem["Fax"].Controls[1] as RadMaskedTextBox).Text;
string Mobile = (insertedItem["Mobile"].Controls[1] as RadMaskedTextBox).Text;
string Email = (insertedItem["Email"].Controls[1] as TextBox).Text;
string Extn = (insertedItem["Extn"].Controls[1] as TextBox).Text;
Repository.Struct.SpResultset resultset = Repository.Shops.InsertContact(ReferenceID, Name, Type, Other, Phone, Fax, Mobile, Email, Extn);
if (resultset.Isresult)
{
contactgrid.Rebind();
e.Item.OwnerTableView.IsItemInserted = false;
}
}
protected void dependencygrid_InsertCommand(object source, GridCommandEventArgs e)
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
string ReferenceID = (insertedItem["Sno"].Controls[3] as Label).Text;
string FirstName = (insertedItem["FirstName"].Controls[1] as TextBox).Text.ToUpper();
string LastName = (insertedItem["LastName"].Controls[1] as TextBox).Text.ToUpper();
string Gender = (insertedItem["Gender"].Controls[3] as RadComboBox).SelectedValue;
bool hasValue = (insertedItem["BirthDate"].Controls[1] as RadDatePicker).SelectedDate.HasValue;
string strBirthDate = (hasValue ? (insertedItem["BirthDate"].Controls[1] as RadDatePicker).SelectedDate.Value.ToShortDateString() : null);
string SSN = (insertedItem["SSN"].Controls[1] as RadMaskedTextBox).Text;
string Relationship = (insertedItem["Relationship"].Controls[3] as RadComboBox).SelectedValue;
bool Beneficiary = (insertedItem["Beneficiary"].Controls[3] as CheckBox).Checked;
Repository.Struct.SpResultset resultset = Repository.Members.InsertDependency(ReferenceID, FirstName, LastName, strBirthDate, SSN, Relationship, Gender, Beneficiary);
if (resultset.Isresult)
{
dependencygrid.Rebind();
e.Item.OwnerTableView.IsItemInserted = false;
}
}
protected void Initiationgrid_InsertCommand(object source, GridCommandEventArgs e)
{
GridDataInsertItem insertedItem = (GridDataInsertItem)e.Item;
string ReferenceID = (insertedItem["Sno"].Controls[3] as Label).Text;
string Date = (insertedItem["Date"].Controls[1] as RadDatePicker).SelectedDate.ToString();
string Amount = (insertedItem["Amount"].Controls[1] as RadNumericTextBox).Text;
switch (Feeoption.SelectedValue)
{
case "1":
Repository.Members.InsertFullFee(ReferenceID, Date);
Initiationgrid.Rebind();
break;
case "2":
Repository.Struct.SpResultset resultset = Repository.Members.InsertPartialFee(ReferenceID, Amount, Date);
if (resultset.Isresult)
{
Initiationgrid.Rebind();
e.Item.OwnerTableView.IsItemInserted = false;
}
break;
}
}
protected void btnPesquisarCEP_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
ImageButton btnPesquisarCEP = (ImageButton)sender;
if (btnPesquisarCEP.NamingContainer is GridDataItem)
{
GridDataItem editItem = (GridDataItem)btnPesquisarCEP.NamingContainer;
RadMaskedTextBox txtCEP = (RadMaskedTextBox)editItem.FindControl("txtCEP");
if (!string.IsNullOrEmpty(txtCEP.Text))
{
RadTextBox txtLogradouro = (RadTextBox)editItem.FindControl("txtLogradouro");
RadTextBox txtBairro = (RadTextBox)editItem.FindControl("txtBairro");
RadTextBox txtCidadeNome = (RadTextBox)editItem.FindControl("txtCidadeNome");
HiddenField hdnCidadeID = (HiddenField)editItem.FindControl("hdnCidadeID");
RadTextBox txtUF = (RadTextBox)editItem.FindControl("txtUF");
RadTextBox txtPaisNome = (RadTextBox)editItem.FindControl("txtPaisNome");
result_BuscarEnderecoCep _buscarEnderecoCep;
using (UnitOfWork oUnitOfWork = new UnitOfWork())
{
_buscarEnderecoCep = oUnitOfWork.EntidadeREP.BuscarEnderecoCep(txtCEP.Text, txtBairro.Text, txtLogradouro.Text, null);
}
if (_buscarEnderecoCep != null)
{
txtLogradouro.Text = _buscarEnderecoCep.Logradouro;
txtBairro.Text = _buscarEnderecoCep.BairroNome;
txtCidadeNome.Text = _buscarEnderecoCep.CidadeNome;
hdnCidadeID.Value = _buscarEnderecoCep.CidadeID.ToString();
txtUF.Text = _buscarEnderecoCep.Sigla;
}
else
{
Utils.Notificar(ntfGeral, "C.E.P não encontrado.", Enums.TipoNotificacao.Alerta);
}
}
else
{
Utils.Notificar(ntfGeral, "Informe um número válido de C.E.P para efetuar a pesquisa.", Enums.TipoNotificacao.Alerta);
}
}
if (btnPesquisarCEP.NamingContainer is GridDataInsertItem)
{
GridDataInsertItem insertItem = (GridDataInsertItem)btnPesquisarCEP.NamingContainer;
RadMaskedTextBox txtCEP = (RadMaskedTextBox)insertItem.FindControl("txtCEP");
if (!string.IsNullOrEmpty(txtCEP.Text))
{
RadTextBox txtLogradouro = (RadTextBox)insertItem.FindControl("txtLogradouro");
RadTextBox txtBairro = (RadTextBox)insertItem.FindControl("txtBairro");
RadTextBox txtCidadeNome = (RadTextBox)insertItem.FindControl("txtCidadeNome");
HiddenField hdnCidadeID = (HiddenField)insertItem.FindControl("hdnCidadeID");
RadTextBox txtUF = (RadTextBox)insertItem.FindControl("txtUF");
RadTextBox txtPaisNome = (RadTextBox)insertItem.FindControl("txtPaisNome");
result_BuscarEnderecoCep _buscarEnderecoCep;
using (UnitOfWork oUnitOfWork = new UnitOfWork())
{
_buscarEnderecoCep = oUnitOfWork.EntidadeREP.BuscarEnderecoCep(txtCEP.Text, txtBairro.Text, txtLogradouro.Text, null);
}
if (_buscarEnderecoCep != null)
{
txtLogradouro.Text = _buscarEnderecoCep.Logradouro;
txtBairro.Text = _buscarEnderecoCep.BairroNome;
txtCidadeNome.Text = _buscarEnderecoCep.CidadeNome;
hdnCidadeID.Value = _buscarEnderecoCep.CidadeID.ToString();
txtUF.Text = _buscarEnderecoCep.Sigla;
}
else
{
Utils.Notificar(ntfGeral, "C.E.P não encontrado.", Enums.TipoNotificacao.Alerta);
}
}
else
{
Utils.Notificar(ntfGeral, "Informe um número válido de C.E.P para efetuar a pesquisa.", Enums.TipoNotificacao.Alerta);
}
}
}
