public static void Filial_Update(Filial filial) { int?filialAddressId; if (filial.FilialAddress.Id <= 0) { filialAddressId = filial.FilialAddress.Set(); } else { if (filial.FilialAddress.IsEmpty()) //Luego del uptade de Filial se borra el registro { filialAddressId = null; } else { filialAddressId = filial.FilialAddress.Id; } } db.ExecuteScalar("spFilialUpdate", filial.Id, filial.TaxpayerId, filial.Birthdate, filial.Birthplace, filial.DocumentType1.Id, filial.DocumentNumber1, filial.DocumentType2.Id, filial.DocumentNumber2, filial.DocumentType3.Id, filial.DocumentNumber3, filialAddressId, filial.Sex.Id, filial.MartialStatus.Id, filial.PdfFile, HttpContext.Current.Session["UserId"]); filial.CopyValuesToOrigValues(); if (filial.FilialAddress.Id > 0) { filialAddressId = filial.FilialAddress.Set(); } }
public static Filial Filial_GetByTaxpayerId(int id) { Filial filial = null; DataSet ds = db.ExecuteDataSet("spFilialGetByTaxpayerId", id); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; filial = new Filial(); filial.Id = Convert.ToInt32(dr["Id"]); filial.TaxpayerId = Convert.ToInt32(dr["TaxpayerId"]); if ((dr["Birthdate"] != DBNull.Value)) { filial.Birthdate = (DateTime?)(dr["Birthdate"]); } filial.Birthplace = dr["Birthplace"].ToString(); filial.DocumentType1 = new Code(Convert.ToInt32(dr["DocumentTypeId1"])); filial.DocumentNumber1 = dr["DocumentNumber1"].ToString(); filial.DocumentType2 = new Code(Convert.ToInt32(dr["DocumentTypeId2"])); filial.DocumentNumber2 = dr["DocumentNumber2"].ToString(); filial.DocumentType3 = new Code(Convert.ToInt32(dr["DocumentTypeId3"])); filial.DocumentNumber3 = dr["DocumentNumber3"].ToString(); if (dr["AddressId"] != DBNull.Value) { filial.FilialAddress = Address_GetById(Convert.ToInt32(dr["AddressId"])); } filial.Sex = new Code(Convert.ToInt32(dr["SexId"])); filial.MartialStatus = new Code(Convert.ToInt32(dr["MartialStatusId"])); filial.PdfFile = dr["PdfFile"].ToString(); filial.CopyValuesToOrigValues(); } return(filial); }
public static int?Filial_Insert(Filial filial) { int?filialAddressId = filial.FilialAddress.Set(); return(Convert.ToInt32(db.ExecuteScalar("spFilialInsert", filial.TaxpayerId, filial.Birthdate, filial.Birthplace, filial.DocumentType1.Id, filial.DocumentNumber1, filial.DocumentType2.Id, filial.DocumentNumber2, filial.DocumentType3.Id, filial.DocumentNumber3, filialAddressId, filial.Sex.Id, filial.MartialStatus.Id, filial.PdfFile, HttpContext.Current.Session["UserId"]))); filial.CopyValuesToOrigValues(); }