public LocationModel Insert(LocationModel model) { try { string query = @"INSERT INTO Location( LocCode ,LocName ,LocLatitude ,LocLongitude ,LocRemarks) output INSERTED.LocId VALUES( @LocCode ,@LocName ,@LocLatitude ,@LocLongitude ,@LocRemarks) "; fun.OpenConnection(); if (fun.getConnection().State == System.Data.ConnectionState.Open) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@LocCode", model.LocCode)); param.Add(new SqlParameter("@LocName", model.LocName)); param.Add(new SqlParameter("@LocLatitude", model.LocLatitude)); param.Add(new SqlParameter("@LocLongitude", model.LocLongitude)); param.Add(new SqlParameter("@LocRemarks", model.LocRemarks)); model.LocId = fun.ExecuteQueryWithParameters(query, param, "Yes"); } else { throw new Exception("Please check Network connection"); } return(model); } catch (Exception ex) { throw ex; } }
public LocationModel GetLocation(int locId) { try { LocationModel model = new LocationModel(); string query = String.Format(@"SELECT [LocId] ,[LocCode] ,[LocName] ,[LocLatitude] ,[LocLongitude] ,[LocRemarks] FROM [Location] WHERE [LocId] = {0}", locId); fun.OpenConnection(); if (fun.getConnection().State == ConnectionState.Open) { DataSet ds = fun.fillComboDataset(query); if (ds.Tables.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { model.LocCode = item["LocCode"].ToString(); model.LocId = locId; model.LocLatitude = item["LocLatitude"].ToString(); model.LocLongitude = item["LocLongitude"].ToString(); model.LocName = item["LocName"].ToString(); model.LocRemarks = item["LocRemarks"].ToString(); } } } else { throw new Exception("Please check network connection"); } return(model); } catch (Exception ex) { throw ex; } }
public LocationModel Update(LocationModel model) { try { string query = @"UPDATE Location SET LocCode = @LocCode ,LocName = @LocName ,LocLatitude = @LocLatitude ,LocLongitude = @LocLongitude ,LocRemarks = @LocRemarks WHERE LocId = @LocId "; fun.OpenConnection(); if (fun.getConnection().State == System.Data.ConnectionState.Open) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@LocId", model.LocId)); param.Add(new SqlParameter("@LocCode", model.LocCode)); param.Add(new SqlParameter("@LocName", model.LocName)); param.Add(new SqlParameter("@LocLatitude", model.LocLatitude)); param.Add(new SqlParameter("@LocLongitude", model.LocLongitude)); param.Add(new SqlParameter("@LocRemarks", model.LocRemarks)); fun.ExecuteQueryWithParameters(query, param); } else { throw new Exception("Please check Network connection"); } return(model); } catch (Exception ex) { throw ex; } }
public LocationModel GetLocationDetails(int LocId) { try { string query = String.Format(@"select LocId,LocCode, LocName, LocLatitude, LocLongitude,LocRemarks from Location where LocId = {0}", LocId); DataSet ds = new DataSet(); LocationModel model = new LocationModel(); fun.OpenConnection(); if (fun.getConnection().State == ConnectionState.Open) { ds = fun.fillComboDataset(query); } else { ds = temp.fillComboDataset(query); } if (ds.Tables.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { model.LocCode = item["LocCode"].ToString(); model.LocId = Convert.ToInt32(item["LocId"].ToString()); model.LocLatitude = item["LocLatitude"].ToString(); model.LocLongitude = item["LocLongitude"].ToString(); model.LocName = item["LocName"].ToString(); model.LocRemarks = item["LocRemarks"].ToString(); } } return(model); } catch (Exception ex) { throw ex; } }