// PUT: api/Citizen/5
public IHttpActionResult Put(int id, CitizenInfoViewModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != model.Id)
{
return(BadRequest());
}
model.Id = id;
bool status = false;
try
{
status = pro.Insert(model);
}
catch (Exception)
{
return(BadRequest());
}
if (status)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(BadRequest());
}
}
public FriendsViewModel(Citizen citizen, IQueryable <Citizen> friends, IFriendService friendService)
{
Info = new CitizenInfoViewModel(citizen, friendService);
Friends = friends
.OrderBy(f => f.Entity.Name)
.ToList() //to make SQL query
.Select(f => new ViewCitizenFriendModel(f))
.ToList();
}
public bool Insert(CitizenInfoViewModel model)
{
using (var con = new SifarishEntities())
{
if (model.Id > 0)
{
// var categorizedProducts = product
//.Join(productcategory, p => p.Id, pc => pc.ProdId, (p, pc) => new { p, pc })
//.Join(category, ppc => ppc.pc.CatId, c => c.Id, (ppc, c) => new { ppc, c })
//.Select(m => new {
// ProdId = m.ppc.p.Id, // or m.ppc.pc.ProdId
// CatId = m.c.CatId
// // other assignments
//})
// var update = con.Citizen_Info.Where(x => x.Id == model.Id).FirstOrDefault();
var data = con.Citizen_Info.Join(con.Citizen_GharJagga_Info,
a => a.Id,
b => b.Citizen_Id,
(a, b) => new { Citizen_Info = a, Citizen_GharJagga_Info = b })
.Join(con.JaagaTarfas, ppc => ppc.Citizen_Info.Id, c => c.CitizenId, (ppc, c) => new { ppc, c })
.Join(con.Karlayatarfas, k => k.ppc.Citizen_Info.Id, z => z.citizen_ID, (k, z) => new { k, z })
.FirstOrDefault();
if (data != null)
{
// data.k.ppc.Citizen_Info.Id = model.Id;
data.k.ppc.Citizen_Info.Citizenship_No = model.Citizenship_No;
data.k.ppc.Citizen_Info.Address = model.Address;
data.k.ppc.Citizen_Info.District_Id = model.District_Id;
data.k.ppc.Citizen_Info.Zone_Id = model.Zone_Id;
data.k.ppc.Citizen_Info.Mun_Ward = model.Mun_Ward;
data.k.ppc.Citizen_Info.Sabik_Ward = model.Sabik_Ward;
data.k.ppc.Citizen_Info.Father_Husband_Name = model.Father_Husband_Name;
data.k.ppc.Citizen_Info.GrandFatherName = model.GrandFatherName;
data.k.ppc.Citizen_Info.CitizenShip_Date = model.CitizenShip_Date;
data.k.ppc.Citizen_Info.CitizinShip_Zone = model.CitizinShip_Zone;
// data.k.ppc.Citizen_GharJagga_Info.Citizen_gharjaga_Id = model.Citizen_gharjaga_Id;
// data.k.ppc.Citizen_GharJagga_Info.Citizen_Id = model.Id;
data.k.ppc.Citizen_GharJagga_Info.Area = model.Area;
data.k.ppc.Citizen_GharJagga_Info.NumberOfHouse = model.NumberOfHouse;
data.k.ppc.Citizen_GharJagga_Info.Kitta_No = model.Kitta_No;
data.k.ppc.Citizen_GharJagga_Info.East = model.East;
data.k.ppc.Citizen_GharJagga_Info.West = model.West;
data.k.ppc.Citizen_GharJagga_Info.North = model.North;
data.k.ppc.Citizen_GharJagga_Info.South = model.South;
data.k.c.MulSadak = model.MulSadak;
data.k.c.KacchiSadak = model.KacchiSadak;
data.k.c.Goreto = model.Goreto;
data.k.c.sahayakSadaK = model.sahayakSadaK;
data.k.c.BatoNavaeko = model.BatoNavaeko;
data.z.Name = model.Name;
data.z.Address = model.KAddress;
data.z.Date = model.Date;
data.z.KardartaFullName = model.KardartaFullName;
con.Entry(data.k.ppc.Citizen_Info).State = System.Data.Entity.EntityState.Modified;
con.Entry(data.k.ppc.Citizen_GharJagga_Info).State = System.Data.Entity.EntityState.Modified;
con.Entry(data.k.c).State = System.Data.Entity.EntityState.Modified;
con.Entry(data.z).State = System.Data.Entity.EntityState.Modified;
// var a= con.SaveChanges();
}
}
else
{
Citizen_Info cdata = new Citizen_Info()
{
Id = model.Id,
Citizenship_No = model.Citizenship_No,
Address = model.Address,
District_Id = model.District_Id,
Zone_Id = model.Zone_Id,
Mun_Ward = model.Mun_Ward,
Sabik_Ward = model.Sabik_Ward,
Father_Husband_Name = model.Father_Husband_Name,
GrandFatherName = model.GrandFatherName,
CitizenShip_Date = model.CitizenShip_Date,
CitizinShip_Zone = model.CitizinShip_Zone,
};
con.Citizen_Info.Add(cdata);
Citizen_GharJagga_Info cgdata = new Citizen_GharJagga_Info()
{
//Citizen_gharjaga_Id = model.Citizen_gharjaga_Id,
Citizen_Id = cdata.Id,
Area = model.Area,
NumberOfHouse = model.NumberOfHouse,
Kitta_No = model.Kitta_No,
East = model.East,
West = model.West,
North = model.North,
South = model.South,
};
con.Citizen_GharJagga_Info.Add(cgdata);
JaagaTarfa jdata = new JaagaTarfa()
{
CitizenId = cdata.Id,
BatoNavaeko = model.BatoNavaeko,
KacchiSadak = model.KacchiSadak,
sahayakSadaK = model.sahayakSadaK,
MulSadak = model.MulSadak,
Goreto = model.Goreto,
};
con.JaagaTarfas.Add(jdata);
Karlayatarfa kdata = new Karlayatarfa()
{
citizen_ID = cdata.Id,
KardartaFullName = model.KardartaFullName,
Name = model.Name,
Address = model.KAddress,
Date = model.Date,
};
con.Karlayatarfas.Add(kdata);
}
int i = con.SaveChanges();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
