public int addTrainingOffer(RepresentativeAddTrainingOffer obj,int repid)
{
string connectionString = Connstr();
string queryString = null;
int locid = 0;
if (obj.Location.CompareTo("Bangalore") == 0)
locid = 1;
else if (obj.Location.CompareTo("Delhi") == 0)
locid = 2;
else if (obj.Location.CompareTo("Kolkata") == 0)
locid = 3;
else if (obj.Location.CompareTo("Pune") == 0)
locid = 4;
else if (obj.Location.CompareTo("Jaipur") == 0)
locid = 5;
string staffStatus = "Pending";
queryString = "INSERT INTO TrainingDetails(TrainingID,RepId,CompanyName,Domain,Graduation,PG,PastExp,StartingDate,Duration,NoOfSeat,TrainingDesc,LocationID,Location,StaffApproval) " +
"values(@train,@rep,@company,@domain,@grad,@post,@exp,@start,@duration,@seats,@desc,@locid,@loc,@staff) ;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
//Generate a six lettered random string
SqlConnection connectionCheck = new SqlConnection(connectionString);
String querycheck = "SELECT count(*) from TrainingDetails Where TrainingID=@trainid COLLATE Latin1_General_CS_AS;";
SqlCommand commandcheck = new SqlCommand(querycheck, connectionCheck);
int checkExist = 1;
string trainid="";
while (checkExist != 0)
{
trainid = RandomString();
commandcheck.Parameters.AddWithValue("@trainid", trainid);
connectionCheck.Open();
checkExist = (int)commandcheck.ExecuteScalar();
connectionCheck.Close();
}
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("@train", trainid);
command.Parameters.AddWithValue("@rep", repid);
command.Parameters.AddWithValue("@company", obj.Company);
command.Parameters.AddWithValue("@domain", obj.domain);
command.Parameters.AddWithValue("@grad", obj.graduation);
command.Parameters.AddWithValue("@post", obj.postGraduation);
command.Parameters.AddWithValue("@exp", obj.Experience);
command.Parameters.AddWithValue("@start", obj.startDate);
command.Parameters.AddWithValue("@duration", obj.duration);
command.Parameters.AddWithValue("@seats", obj.noOfSeats);
command.Parameters.AddWithValue("@desc", obj.description);
command.Parameters.AddWithValue("@locid", locid);
command.Parameters.AddWithValue("@loc", obj.Location);
command.Parameters.AddWithValue("@staff", staffStatus);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return repid;
}
public ActionResult addTrainingTODb(RepresentativeAddTrainingOffer obj)
{
int id = (int)Session["UserID"];
string comp = (string)Session["UserName"];
obj.Company = comp;
int val = new DataAccess.RepresentativeDAL().addTrainingOffer(obj, id);
return View("SuccessPage");
}
