//Builty Detail
public ActionResult BuiltyDetail(int id = 0)
{
var BuiltyDetail = new BuiltyCrudViewModel();
Builty builtydetail = BuiltyDetail.Editbuilty(id);
return(View(builtydetail));
}
public ActionResult CompanyBuilty(int id = 0)
{
Builty editBuilty = new Builty();
var method = new BuiltyCrudViewModel();
//Callthis Method from VehicleCRudView
var viewmodel = new BuiltyViewModel();
if (id != 0)
{
editBuilty = method.Editbuilty(id);
}
viewmodel.Builty = editBuilty;
return(View(viewmodel));
}
public Builty Editbuilty(int id)
{
Builty builty = new Builty();
string connection = ConfigurationManager.ConnectionStrings["MalikDb"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("sp_Builty_Select", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BuiltyId ", id);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
builty.BuiltyNumber = int.Parse(sdr["BuiltyNumber"].ToString());
builty.BuiltyTruckNumber = sdr["BuiltyTruckNumber"].ToString();
builty.BuiltyDate = sdr["BuiltyDate"].ToString();
builty.BuiltyDriver = sdr["BuiltyDriver"].ToString();
builty.BuiltySource = sdr["BuiltySource"].ToString();
builty.BuiltyDestination = sdr["BuiltyDestination"].ToString();
builty.BuiltySeller = sdr["BuiltySender"].ToString();
builty.BuiltyBuyer = sdr["BuiltyReciever"].ToString();
builty.BuiltyQuantity = sdr["BuiltyQuantity"].ToString();
builty.BuiltyGoodsDetail = sdr["BuiltyGoodsDetail"].ToString();
builty.BuiltyWeight = sdr["BuiltyWeight"].ToString();
builty.BuiltyFare = int.Parse(sdr["BuiltyFare"].ToString());
builty.BuiltyAdvance = int.Parse(sdr["BuiltyAdvance"].ToString());
builty.BuiltyRemainingPayment = int.Parse(sdr["BuiltyRemainingPayment"].ToString());
builty.BuiltyDriverNumber = sdr["BuiltyDriverNumber"].ToString();
builty.BuiltyDriverId = sdr["BuiltyDriverId"].ToString();
builty.BuiltyRate = int.Parse(sdr["BuiltyRate"].ToString());
builty.BuiltyFinalFare = int.Parse(sdr["BuiltyFinalFare"].ToString());
builty.BuiltyType = sdr["BuiltyType"].ToString();
builty.BuiltyVehicleSize = sdr["BuiltyVehicleSize"].ToString();
}
}
con.Close();
return(builty);
}
public List <Builty> GetAllBuilty()
{
var builtylist = new List <Builty>();
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("sp_Builty_GetAllBuilty", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
var builty = new Builty();
builty.BuiltyNumber = int.Parse(dr["BuiltyNumber"].ToString());
builty.BuiltyTruckNumber = dr["BuiltyTruckNumber"].ToString();
builty.BuiltyDate = dr["BuiltyDate"].ToString();
builty.BuiltyDriver = dr["BuiltyDriver"].ToString();
builty.BuiltySource = dr["BuiltySource"].ToString();
builty.BuiltyDestination = dr["BuiltyDestination"].ToString();
builty.BuiltySeller = dr["BuiltySender"].ToString();
builty.BuiltyBuyer = dr["BuiltyReciever"].ToString();
builty.BuiltyQuantity = dr["BuiltyQuantity"].ToString();
builty.BuiltyGoodsDetail = dr["BuiltyGoodsDetail"].ToString();
builty.BuiltyWeight = dr["BuiltyWeight"].ToString();
builty.BuiltyFare = int.Parse(dr["BuiltyFare"].ToString());
builty.BuiltyAdvance = int.Parse(dr["BuiltyAdvance"].ToString());
builty.BuiltyRemainingPayment = int.Parse(dr["BuiltyRemainingPayment"].ToString());
builty.BuiltyDriverNumber = dr["BuiltyDriverNumber"].ToString();
builty.BuiltyDriverId = dr["BuiltyDriverId"].ToString();
builty.BuiltyRate = int.Parse(dr["BuiltyRate"].ToString());
builty.BuiltyFinalFare = int.Parse(dr["BuiltyFinalFare"].ToString());
builty.BuiltyType = dr["BuiltyType"].ToString();
builtylist.Add(builty);
}
}
con.Close();
return(builtylist);
}
public IEnumerable <Builty> GetAllBuilty(int livecompanyid)
{
List <Builty> ridelist = new List <Builty>();
string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("sp_Builty_GetAllBuilty", con);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@CompanyId", livecompanyid);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
Builty builty = new Builty();
builty.BuiltyId = int.Parse(sdr["BuiltyId"].ToString());
builty.BuiltySource = sdr["BuiltySource"].ToString();
builty.BuiltyDestination = sdr["BuiltyDestination"].ToString();
builty.BuiltyVehicleNumber = sdr["BuiltyVehicleNumber"].ToString();
builty.BuiltySeller = sdr["BuiltySellerName"].ToString();
builty.BuiltyBuyer = sdr["BuiltyBuyerName"].ToString();
builty.BuiltyDate = DateTime.Parse(sdr["BuiltyDate"].ToString()).Date;
builty.BuiltyDetail = sdr["BuiltyDetail"].ToString();
ridelist.Add(builty);
}
}
con.Close();
return(ridelist.AsEnumerable());
}
public Builty editbuilty(int id, int companyid)
{
Builty builty = new Builty();
string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("sp_Builty_Select", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BuiltyId ", id);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
builty.BuiltyId = int.Parse(sdr["BuiltyId"].ToString());
builty.BuiltySource = sdr["BuiltySource"].ToString();
builty.BuiltyDestination = sdr["BuiltyDestination"].ToString();
builty.DriverName = sdr["DriverName"].ToString();
builty.VehicleSize = sdr["VehicleSize"].ToString();
builty.BuiltyGoodsQuantaty = sdr["quantity"].ToString();
builty.BuiltyVehicleNumber = sdr["BuiltyVehicleNumber"].ToString();
builty.BuiltySeller = sdr["BuiltySellerName"].ToString();
builty.BuiltyBuyer = sdr["BuiltyBuyerName"].ToString();
builty.DriverPhoneNumber = sdr["DriverNumber"].ToString();
builty.BuiltyDate = DateTime.Parse(sdr["BuiltyDate"].ToString());
builty.BuiltyDetail = sdr["BuiltyDetail"].ToString();
builty.BuiltyWeight = sdr["BuiltyWeight"].ToString();
}
}
con.Close();
return(builty);
}
public DataSet BuiltyUpdate(Builty builty)
{
if (builty.BuiltyTruckNumber != null)
{
builty.BuiltyTruckNumber = builty.BuiltyTruckNumber.ToUpper();
}
string connection = ConfigurationManager.ConnectionStrings["MalikDb"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
DataSet ds = new FinalBuiltyDataSet();
con.Open();
SqlCommand cmd = new SqlCommand("sp_Builty_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BuiltyNumber", builty.BuiltyNumber);
cmd.Parameters.AddWithValue("@BuiltyVehicleNumber", builty.BuiltyTruckNumber);
cmd.Parameters.AddWithValue("@BuiltyDate", builty.BuiltyDate);
cmd.Parameters.AddWithValue("@BuiltyDriverName", builty.BuiltyDriver);
cmd.Parameters.AddWithValue("@BuiltySource", builty.BuiltySource);
cmd.Parameters.AddWithValue("@BuiltyDestination", builty.BuiltyDestination);
cmd.Parameters.AddWithValue("@BuiltySellerName", builty.BuiltySeller);
cmd.Parameters.AddWithValue("@BuiltyBuyerName", builty.BuiltyBuyer);
cmd.Parameters.AddWithValue("@Quantity", builty.BuiltyQuantity);
cmd.Parameters.AddWithValue("@BuiltyDetail", builty.BuiltyGoodsDetail);
cmd.Parameters.AddWithValue("@BuiltyWeight", builty.BuiltyWeight);
cmd.Parameters.AddWithValue("@BuiltyFare", builty.BuiltyFare);
cmd.Parameters.AddWithValue("@BuiltyAdvance", builty.BuiltyAdvance);
cmd.Parameters.AddWithValue("@BuiltyRemainingPayment", builty.BuiltyRemainingPayment);
cmd.Parameters.AddWithValue("@BuiltyDriverNumber", builty.BuiltyDriverNumber);
cmd.Parameters.AddWithValue("@BuiltyDriverId", builty.BuiltyDriverId);
cmd.Parameters.AddWithValue("@BuiltyRate", builty.BuiltyRate);
cmd.Parameters.AddWithValue("@BuiltyFinalFare", builty.BuiltyFinalFare);
cmd.Parameters.AddWithValue("@BuiltyType", builty.BuiltyType);
cmd.Parameters.AddWithValue("@BuiltyVehicleSize", builty.BuiltyVehicleSize);
string message = "";
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
message = "Ride Updated Successfully";
}
con.Close();
using (SqlCommand cm = new SqlCommand("sp_Builty_Report", con))
{
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@BuiltyNumber", builty.BuiltyNumber);
SqlDataAdapter sda = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
string firstname = r["BuiltyDriverNumber"].ToString();
}
}
sda.Fill(ds, "tbl_Builty");
}
return(ds);
}
public DataSet SaveBuilty(Builty builty)
{
int BuiltyId = 0;
DataSet ds = new FinalBuiltyDataSet();
string connection = ConfigurationManager.ConnectionStrings["MalikDb"].ConnectionString;
if (builty.BuiltyTruckNumber != null)
{
builty.BuiltyTruckNumber = builty.BuiltyTruckNumber.ToUpper();
}
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd0 = new SqlCommand("sp_Vehicle_VehicleExist", con);
cmd0.CommandType = CommandType.StoredProcedure;
cmd0.Parameters.AddWithValue("@VehicleNumber", builty.BuiltyTruckNumber);
SqlDataReader sdr = cmd0.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
var VehicleInDB = new Vehicle();
VehicleInDB.VehicleDriver = sdr["VehicleDriver"].ToString();
VehicleInDB.VehicleDriverCNIC = sdr["VehicleDriverCNIC"].ToString();
VehicleInDB.VehiclePhoneNumber = sdr["VehiclePhoneNumber"].ToString();
VehicleInDB.VehicleSize = sdr["VehicleSize"].ToString();
if (VehicleInDB.VehicleDriver != builty.BuiltyDriver || VehicleInDB.VehicleDriverCNIC != builty.BuiltyDriverId || VehicleInDB.VehiclePhoneNumber != builty.BuiltyDriverNumber || VehicleInDB.VehicleSize != builty.BuiltyVehicleSize)
{
SqlCommand cmd1 = new SqlCommand("sp_Vehicle_VehicleUpdate", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@VehicleNumber", builty.BuiltyTruckNumber);
cmd1.Parameters.AddWithValue("@DriverName", builty.BuiltyDriver);
cmd1.Parameters.AddWithValue("@DriverPhoneNumber", builty.BuiltyDriverNumber);
cmd1.Parameters.AddWithValue("@VehicleDriverCNIC", builty.BuiltyDriverId);
cmd1.Parameters.AddWithValue("@VehicleSize", builty.BuiltyVehicleSize);
cmd1.ExecuteNonQuery();
}
}
}
else if (builty.BuiltyTruckNumber != null)
{
SqlCommand cmd1 = new SqlCommand("sp_Vehicle_VehicleAdd", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@VehicleNumber", builty.BuiltyTruckNumber);
cmd1.Parameters.AddWithValue("@DriverName", builty.BuiltyDriver);
cmd1.Parameters.AddWithValue("@DriverPhoneNumber", builty.BuiltyDriverNumber);
cmd1.Parameters.AddWithValue("@VehicleDriverCNIC", builty.BuiltyDriverId);
cmd1.Parameters.AddWithValue("@VehicleSize", builty.BuiltyVehicleSize);
cmd1.ExecuteNonQuery();
}
builty.BuiltyRemainingPayment = builty.BuiltyFare + builty.BuiltyAdvance;
builty.BuiltyFinalFare = builty.BuiltyRemainingPayment;
SqlCommand cmd = new SqlCommand("sp_NewBuilty", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BuiltyVehicleNumber", builty.BuiltyTruckNumber);
cmd.Parameters.AddWithValue("@BuiltyDate", builty.BuiltyDate);
cmd.Parameters.AddWithValue("@BuiltyDriverName", builty.BuiltyDriver);
cmd.Parameters.AddWithValue("@BuiltySource", builty.BuiltySource);
cmd.Parameters.AddWithValue("@BuiltyDestination", builty.BuiltyDestination);
cmd.Parameters.AddWithValue("@BuiltySellerName", builty.BuiltySeller);
cmd.Parameters.AddWithValue("@BuiltyBuyerName", builty.BuiltyBuyer);
cmd.Parameters.AddWithValue("@Quantity", builty.BuiltyQuantity);
cmd.Parameters.AddWithValue("@BuiltyDetail", builty.BuiltyGoodsDetail);
cmd.Parameters.AddWithValue("@BuiltyWeight", builty.BuiltyWeight);
cmd.Parameters.AddWithValue("@BuiltyFare", builty.BuiltyFare);
cmd.Parameters.AddWithValue("@BuiltyAdvance", builty.BuiltyAdvance);
cmd.Parameters.AddWithValue("@BuiltyRemainingPayment", builty.BuiltyRemainingPayment);
cmd.Parameters.AddWithValue("@BuiltyDriverNumber", builty.BuiltyDriverNumber);
cmd.Parameters.AddWithValue("@BuiltyDriverId", builty.BuiltyDriverId);
cmd.Parameters.AddWithValue("@BuiltyRate", builty.BuiltyRate);
cmd.Parameters.AddWithValue("@BuiltyFinalFare", builty.BuiltyFinalFare);
cmd.Parameters.AddWithValue("@BuiltyType", builty.BuiltyType);
cmd.Parameters.AddWithValue("@BuiltyVehicleSize", builty.BuiltyVehicleSize);
SqlDataAdapter SDA = new SqlDataAdapter(cmd);
DataTable DT = new DataTable();
SDA.Fill(DT);
if (DT.Rows.Count > 0)
{
foreach (DataRow Row in DT.Rows)
{
BuiltyId = int.Parse(Row["BuiltyNumber"].ToString());
}
}
con.Close();
cmd.Dispose();
using (SqlCommand cm = new SqlCommand("sp_Builty_Report", con))
{
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@BuiltyNumber", BuiltyId);
SqlDataAdapter sda = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
string firstname = r["BuiltySource"].ToString();
string lastname = r["BuiltyDriver"].ToString();
}
}
sda.Fill(ds, "tbl_Builty");
}
return(ds);
}
public ActionResult CompanyBuilty(Builty builty)
{
var ReportData = new DataSet();
string message = "";
var method = new BuiltyCrudViewModel();
var viewmodel = new BuiltyViewModel();
// ModelState["BuiltyNumber"].Errors.Clear();
if (ModelState.IsValid)
{
if (builty.BuiltyNumber == 0)
{
try
{
ReportData = method.SaveBuilty(builty);
if (ReportData.Tables[0].Rows.Count != 0)
{
TempData["ReportData"] = ReportData;
TempData["Type"] = builty.BuiltyType;
TempData.Keep();
return(RedirectToAction("GenerateBuilty", "Admin"));
}
}
catch (Exception e)
{
message = e.Message;
}
// return RedirectToAction("builtyhome", "Admin", new { livecompanyid = Session["user_Id"] });
}
else
{
try
{
ReportData = method.BuiltyUpdate(builty);
if (ReportData.Tables[0].Rows.Count != 0)
{
TempData["ReportData"] = ReportData;
TempData["Type"] = builty.BuiltyType;
TempData.Keep();
return(RedirectToAction("GenerateBuilty", "Admin"));
}
}
catch (Exception e)
{
message = e.Message;
}
/* if (message != "")
* {
* TempData["message"] = "Builty update sucessfully";
* TempData.Keep();
* return RedirectToAction("builtyhome", "Admin", new { livecompanyid = Session["user_Id"] });
* }
* else
* {*/
// return RedirectToAction("builtyhome", "Admin", new { livecompanyid = Session["user_Id"] });
}
}
TempData["GenerateBuiltyMessage"] = message;
/* viewmodel = new BuiltyViewModel()
* {
* builty = builty
* };
*/
viewmodel.Builty = builty;
return(View(viewmodel));
}
public ActionResult FactoryBuilty(Builty builty)
{
return(View());
}
public DataSet BuiltyUpdate(Builty builty)
{
string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
DataSet ds = new BuiltyDataSet();
con.Open();
SqlCommand cmd = new SqlCommand("sp_Builty_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BuiltyId", builty.BuiltyId.ToString());
cmd.Parameters.AddWithValue("@BuiltyVehicleNumber", builty.BuiltyVehicleNumber.ToString());
cmd.Parameters.AddWithValue("@BuiltySellerName", builty.BuiltySeller.ToString());
cmd.Parameters.AddWithValue("@BuiltyBuyerName", builty.BuiltyBuyer.ToString());
cmd.Parameters.AddWithValue("@BuiltySource", builty.BuiltySource.ToString());
cmd.Parameters.AddWithValue("@BuiltyDestination", builty.BuiltyDestination.ToString());
cmd.Parameters.AddWithValue("@BuiltyDate", builty.BuiltyDate.ToString());
cmd.Parameters.AddWithValue("@DriverNumber", builty.DriverPhoneNumber.ToString());
cmd.Parameters.AddWithValue("@BuiltyDriverName", builty.DriverName.ToString());
cmd.Parameters.AddWithValue("@BuiltyVehicleSize", builty.VehicleSize.ToString());
cmd.Parameters.AddWithValue("@Quantity", builty.BuiltyGoodsQuantaty.ToString());
cmd.Parameters.AddWithValue("@BuiltyDetail", builty.BuiltyDetail.ToString());
cmd.Parameters.AddWithValue("@BuiltyWeight", builty.BuiltyWeight.ToString());
string message = "";
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
message = "Ride Added Successfully";
}
con.Close();
using (SqlCommand cm = new SqlCommand("sp_Builty_Report", con))
{
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@BuiltyId", builty.BuiltyId);
SqlDataAdapter sda = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
string firstname = r["DriverNumber"].ToString();
}
}
sda.Fill(ds, "tbl_Builty");
}
return(ds);
}
public DataSet Builty(Builty builty)
{
int BuiltyId = 0;
DataSet ds = new FinalBuiltyDataSet();
string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd0 = new SqlCommand("sp_Vehicle_VehicleExist", con);
cmd0.CommandType = CommandType.StoredProcedure;
cmd0.Parameters.AddWithValue("@VehicleNumber", builty.BuiltyVehicleNumber);
SqlDataReader sdr = cmd0.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
if (sdr["DriverName"] != builty.DriverName || sdr["DriverPhoneNumber"] != builty.DriverPhoneNumber || sdr["VehicleSize"] != builty.VehicleSize)
{
SqlCommand cmd1 = new SqlCommand("sp_Vehicle_VehicleUpdate", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@VehicleNumber", builty.BuiltyVehicleNumber);
cmd1.Parameters.AddWithValue("@DriverName", builty.DriverName);
cmd1.Parameters.AddWithValue("@DriverPhoneNumber", builty.DriverPhoneNumber);
cmd1.Parameters.AddWithValue("@VehicleSize", builty.VehicleSize);
cmd1.ExecuteNonQuery();
}
}
}
else
{
SqlCommand cmd1 = new SqlCommand("sp_Vehicle_VehicleAdd", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@VehicleNumber", builty.BuiltyVehicleNumber);
cmd1.Parameters.AddWithValue("@DriverName", builty.DriverName);
cmd1.Parameters.AddWithValue("@DriverPhoneNumber", builty.DriverPhoneNumber);
cmd1.Parameters.AddWithValue("@VehicleSize", builty.VehicleSize);
cmd1.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("sp_NewBuilty", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BuiltyVehicleNumber", builty.BuiltyVehicleNumber.ToString());
cmd.Parameters.AddWithValue("@BuiltySellerName", builty.BuiltySeller.ToString());
cmd.Parameters.AddWithValue("@BuiltyBuyerName", builty.BuiltyBuyer.ToString());
cmd.Parameters.AddWithValue("@BuiltySource", builty.BuiltySource.ToString());
cmd.Parameters.AddWithValue("@BuiltyDestination", builty.BuiltyDestination.ToString());
cmd.Parameters.AddWithValue("@BuiltyDate", builty.BuiltyDate.ToString());
cmd.Parameters.AddWithValue("@DriverNumber", builty.DriverPhoneNumber.ToString());
cmd.Parameters.AddWithValue("@BuiltyDriverName", builty.DriverName.ToString());
cmd.Parameters.AddWithValue("@BuiltyVehicleSize", builty.VehicleSize.ToString());
cmd.Parameters.AddWithValue("@Quantity", builty.BuiltyGoodsQuantaty.ToString());
cmd.Parameters.AddWithValue("@BuiltyDetail", builty.BuiltyDetail.ToString());
cmd.Parameters.AddWithValue("@BuiltyWeight", builty.BuiltyWeight.ToString());
SqlDataAdapter SDA = new SqlDataAdapter(cmd);
DataTable DT = new DataTable();
SDA.Fill(DT);
if (DT.Rows.Count > 0)
{
foreach (DataRow Row in DT.Rows)
{
BuiltyId = int.Parse(Row["BuiltyId"].ToString());
}
}
con.Close();
cmd.Dispose();
using (SqlCommand cm = new SqlCommand("sp_Builty_Report", con))
{
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@BuiltyId", BuiltyId);
SqlDataAdapter sda = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
string firstname = r["BuiltySource"].ToString();
string lastname = r["DriverName"].ToString();
}
}
sda.Fill(ds, "tbl_Builty");
}
return(ds);
}
public BuiltyViewModel(Models.Builty builty)
{
// TODO: Complete member initialization
this.builty = builty;
}
