public int SaveOrUpdateMaster(TeamMaster objTeamMaster, SqlConnection con, SqlTransaction trans)
{
SqlCommand com = null;
int LastID = 0;
try
{
com = new SqlCommand("spInsertUpdateTeamMaster", con, trans);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@TeamID", SqlDbType.Int).Value = objTeamMaster.intTeamID;
com.Parameters.Add("@TeamNo", SqlDbType.VarChar, 100).Value = objTeamMaster.strTeamNo;
com.Parameters.Add("@TeamName", SqlDbType.VarChar, 100).Value = objTeamMaster.strTeamName;
com.Parameters.Add("@BranchID", SqlDbType.Int).Value = objTeamMaster.intBranchID;
com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = LogInInfo.CompanyID;
com.Parameters.Add("@UserID", SqlDbType.Int).Value = LogInInfo.UserID;
com.ExecuteNonQuery();
if (objTeamMaster.intTeamID == 0)
{
SqlCommand cmd = new SqlCommand("Select ISNULL(MAX(TeamID),0) FROM T_Team_Master WHERE CompanyID = " + LogInInfo.CompanyID, con, trans);
LastID = Convert.ToInt32(cmd.ExecuteScalar());
}
else
{
LastID = objTeamMaster.intTeamID;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(LastID);
}
public ActionResult DeleteConfirmed(int id)
{
TeamMaster teamMaster = db.TeamMasters.Find(id);
db.TeamMasters.Remove(teamMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TID,UserName,TLName,ManagerName")] TeamMaster teamMaster)
{
if (ModelState.IsValid)
{
db.Entry(teamMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teamMaster));
}
/// <summary>
/// Delete the TeamMaster
/// </summary>
/// <param name="teamMaster"></param>
/// <returns></returns>
public bool DeleteTeamMaster(TeamMaster teamMaster)
{
if (teamMaster == null)
{
throw new ArgumentNullException("teamMaster is null");
}
bool result = _teamMasterRepository.Delete(teamMaster);
return(result);
}
public HttpResponseMessage UpdateTeamMaster(TeamMaster teamMaster)
{
//先读取对象到上下文中，再更新
//var newObj = _teamMasterService.GetTeamMasterById(teamMaster.Id);
//newObj.TeamName = teamMaster.TeamName;
//var result = _teamMasterService.UpdateTeamMaster(newObj);
//直接用SingleUpdate更新单个对象
var result = _teamMasterService.UpdateTeamMaster(teamMaster);
return(result ? toJson(null, OperatingState.Success, "修改成功") : toJson(null, OperatingState.Failure, "修改失败"));
}
//this method will add team to a project
public Task AddTeam(TeamMaster team)
{
try
{
_service.AddTeam(team);
return(Clients.Client(Context.ConnectionId).InvokeAsync("whenAdded", "success"));
}
catch (Exception n)
{
logger.LogError("Method {0}, Description: {1}, Source: {2},Exception: {3}", n.TargetSite, n.Message, n.Source, n.ToString());
throw;
}
}
// GET: admin/TeamBuild/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TeamMaster teamMaster = db.TeamMasters.Find(id);
if (teamMaster == null)
{
return(HttpNotFound());
}
return(View(teamMaster));
}
public ActionResult Create([Bind(Include = "TID,UserName,TLName,ManagerName")] TeamMaster teamMaster)
{
try
{
db.TeamMasters.Add(teamMaster);
db.SaveChanges();
TempData["Message"] = "Team Detail Saved!";
}
catch (Exception ex)
{
TempData["Error"] = ex.Message;
}
return(RedirectToAction("Index"));
}
public HttpResponseMessage InsertTeamMaster(TeamMaster teamMaster)
{
var newObj = new TeamMaster()
{
Id = Guid.NewGuid(),
Contact = teamMaster.Contact,
Note = teamMaster.Note,
OrganizationCode = teamMaster.OrganizationCode,
ProjectCode = teamMaster.ProjectCode,
ResponsiblePersonIDNumber = teamMaster.ResponsiblePersonIDNumber,
TeamLeader = teamMaster.TeamLeader,
TeamLeaderIDNumber = teamMaster.TeamLeaderIDNumber,
TeamName = teamMaster.TeamName,
TeamSysNo = teamMaster.TeamSysNo
};
var result = _teamMasterService.InsertTeamMaster(newObj);
return(result ? toJson(null, OperatingState.Success, "添加成功") : toJson(null, OperatingState.Failure, "添加失败"));
}
public void TeamsService_addTeam_should_Throw_FormatException()
{
//arrange
TeamMaster master = new TeamMaster()
{
TeamId = 1
};
List <TeamMaster> team = new List <TeamMaster>();
team.Add(master);
var mockRepo = new Mock <ITeamRepo>();
mockRepo.Setup(m => m.AddTeam(It.IsAny <TeamMaster>())).Throws(new FormatException());
TeamService teamService = new TeamService(mockRepo.Object);
//act
var ex = Record.Exception(() => teamService.AddTeam(master));
//assert
Assert.IsType <FormatException>(ex);
}
public void Checking_return_type_of_GetTeam()
{
//arrange
TeamMaster master = new TeamMaster()
{
TeamId = 1
};
List <TeamMaster> team = new List <TeamMaster>();
team.Add(master);
var mockRepo = new Mock <ITeamRepo>();
mockRepo.Setup(m => m.GetTeam()).Returns(team);
TeamService teamService = new TeamService(mockRepo.Object);
//act
var result = teamService.GetTeam(It.IsAny <int>());
//assert
Assert.IsNotType <List <TeamMember> >(result);
}
public void GetTeam_should_not_return_null()
{
//arrange
TeamMaster master = new TeamMaster()
{
TeamId = 1
};
List <TeamMaster> team = new List <TeamMaster>();
team.Add(master);
var mockRepo = new Mock <ITeamRepo>();
mockRepo.Setup(m => m.GetTeam()).Returns(team);
TeamService teamService = new TeamService(mockRepo.Object);
//act
var result = teamService.GetTeam(It.IsAny <int>());
//assert
Assert.NotNull(result);
}
public int SaveOrUpdateMaster(TeamMaster objTeamMaster, SqlConnection con)
{
SqlCommand com = null;
SqlTransaction trans = null;
int LastID = 0;
try
{
com = new SqlCommand();
trans = con.BeginTransaction("l1");
com.Transaction = trans;
com.Connection = con;
com.CommandText = "spInsertUpdateTeamMaster";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@TeamID", SqlDbType.Int).Value = objTeamMaster.intTeamID;
com.Parameters.Add("@TeamNo", SqlDbType.VarChar, 100).Value = objTeamMaster.strTeamNo;
com.Parameters.Add("@TeamName", SqlDbType.VarChar, 100).Value = objTeamMaster.strTeamName;
com.Parameters.Add("@BranchID", SqlDbType.Int).Value = objTeamMaster.intBranchID;
com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = LogInInfo.CompanyID;
com.Parameters.Add("@UserID", SqlDbType.Int).Value = LogInInfo.UserID;
com.ExecuteNonQuery();
trans.Commit();
if (objTeamMaster.intTeamID == 0)
{
LastID = ConnectionHelper.GetID(con, "TeamID", "T_Team_Master");
}
else
{
LastID = objTeamMaster.intTeamID;
}
}
catch (Exception ex)
{
trans.Rollback("l1");
throw new Exception("Unable to Save or Update" + ex.Message);
}
return(LastID);
}
protected void btnSave_Click(object sender, EventArgs e)
{
// string CmCode = txtCustCategoryCode.Text.Trim().Split(Constants.splitseperator)[0].ToString().Trim();
TeamMaster _objDs = new TeamMaster();
_objDs.TMID = Convert.ToInt32(lblTMID.Text);
_objDs.TNAME = txttname.Text.Trim();
_objDs.TDESC = txtdesc.Text.Trim();
_objDs.CIsActive = ChekActive.Checked;
try
{
if (txttname.Text != "")
{
_objDs.CSave();
}
MessageBox("Record saved successfully");
if (btnSave.Text == "Update")
{
BindGvCCDetail();
PnlAddCC.Visible = false;
PnlCCDetails.Visible = true;
btnSave.Text = "Save";
txttname.Text = "";
txtdesc.Text = "";
}
else
{
BindGvCCDetail();
txttname.Text = "";
txtdesc.Text = "";
ChekActive.Checked = true;
PnlAddCC.Visible = true;
PnlCCDetails.Visible = false;
}
}
catch
{
}
}
protected void GrdCCDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
TeamMaster _objDs2 = new TeamMaster();
_objDs2.TMID = Convert.ToInt32(((Label)GrdCCDetails.Rows[e.RowIndex].FindControl("lblTMID")).Text);
_objDs2.TNAME = ((Label)GrdCCDetails.Rows[e.RowIndex].FindControl("lblTMNAME")).Text;
_objDs2.TDESC = ((Label)GrdCCDetails.Rows[e.RowIndex].FindControl("lbltdesc")).Text;
_objDs2.CIsActive = Convert.ToBoolean(false);
_objDs2.CIsDeleted = Convert.ToBoolean(true);
try
{
_objDs2.CSave();
MessageBox("Your record is Deleted");
BindGvCCDetail();
PnlCCDetails.Visible = true;
PnlAddCC.Visible = false;
}
catch
{
}
}
public void Bind_DDL_TeamName()
{
DDLTeamName.DataSource = TeamMaster.GetTeamMaster("adminCCM");
DDLTeamName.DataBind();
DDLTeamName.Items.Insert(0, new ListItem("---Select Team---", "none"));
}
public void BindGvCCDetail()
{
GrdCCDetails.DataSource = TeamMaster.GetTeamMaster("adminCCM");
GrdCCDetails.DataBind();
}
//this method will add team to a project
public void AddTeam(TeamMaster team)
{
_AgpromaDbContext.Teammaster.Add(team);
_AgpromaDbContext.SaveChanges();
}
//this method will add team to a project
public void AddTeam(TeamMaster team)
{
_teamRepo.AddTeam(team);
}
public void Post([FromBody] TeamMaster team)
{
_service.AddTeam(team);
}
